Excel Countif

How to Count Cells That Contain Specific Text

This post will discuss that how to count the number of cells that contain specific text or certain text in a specified cells of range in Excel. How to get the total number of cells that contain certain text.  Count Cells That Contain Specific Text Assuming that you have a data of list in range… read more »

Find Duplicate Values in Two Columns

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so that the duplicate values can be highlighted or listed in a range of Cells. Assuming… read more »

Highlight Duplicate Rows

This tutorial will teach you how to highlight duplicates rows using conditional formatting feature in Excel. In the previous post, we talked that how to change the color of rows based on a certain number or text or begin a specific character in a specified column. And this post will talk that how to highlight… read more »

Count Duplicates

This post will guide you how to count for duplicates in Excel. You will learn how to count the instances of each duplicate value in a column.  You can use the COUNTIF function to count the duplicate values in a column in Excel. If you have a list of data that contain duplicated values in… read more »

How to Count Numbers with Leading Zeros

This post explains that how to count numbers with leading zeros as Text format in excel. How to count numeric format strings with a different number of leading zeros using excel formula. Count Strings with Leading Zeros Suppost you have a list of product ID in your worksheet, and the product ID contains the different… read more »

How to Extract a List of Unique Values from a Column Range

This post explains that how to get the unique values from a range or column in excel. How to extract unique values from a list or excel range in excel 2013. Extract unique values If you want to extract a list of unique items from a column or range, you can use a combination of… read more »

How to Get the First Match in Two Excel Ranges

This post will guide you how to get the first match value in two ranges in excel. How to return the first occurrence of the value in two excel ranges. Get the First Match in two Ranges If you want to find the first match between two excel ranges, you can use a combination of… read more »

COUNTIF Function in Excel

This post will guide you how to use the COUNTIF function with syntax and examples in Microsoft excel. Description The Excel COUNTIF function will count the number of cells in a range that meet a given criteria. This function can be used to count the different kinds of cells with number, date, text values, blank, non-blanks,… read more »

Sidebar