Excel Countif

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 »

Excel IF function with text values

Normally, If you want to write an IF formula for text values in combining with the below two logical operators in excel, such as: “equal to” or “not equal to”. Excel IF function check if a cell contains text(case-insensitive) By default, IF function is case-insensitive in excel. It means that the logical text for text values… read more »

Excel nested if statements with ranges

Many people usually asked that how to write an excel nested if statements based on multiple ranges of cells to return different values in a cell? How to nested if statement using date ranges? How to use nested if statement between different values in excel 2013 or 2016? Nested IF statements based on multiple ranges Nested… read more »