COUNTIF Function

How to Count Unique Values in Excel Using Pivot Table

In Excel, we need to perform various count operations, i.g. count text cells, count unique, counting duplicates, and many more. Today we are going to ...

Create a Unique List in Excel Based on Criteria (9 Methods)

In Microsoft Excel, several methods are available to create a unique list under multiple criteria. The unique list is generally prepared to remove ...

How to Link a Cell Value with a Drop Down List in Excel (5 Ways)

The drop-down list is a great helper When you are working with a large database and you need to pick a specific item from a list. Using a drop-down ...

How to Populate a List Based on Cell Value in Excel (6 Ways)

In MS Excel, sometimes we may need to determine or find values based on some criteria or condition from a list. Assuming we have a task plan with the ...

VLOOKUP with Multiple Matches in Excel

Today I will be showing how to use VLOOKUP to extract multiple matches in Excel. One of the most amazing and widely used functions of Excel is ...

Excel Partial Match Two Columns (4 Simple Approaches)

Depending on the circumstances you may need to compare a couple of columns. The comparison can be done in many forms, one of them is partial ...

Partial Match with IF in Excel (4 Basic Operations)

IF is one of the most common functions in Excel. Depending on circumstances different logical operations can be performed through this function. We ...

COUNTIF Cell That Contains a Specific Text in Excel (Case-Sensitive and Insensitive)

Today I will be showing how you can use COUNTIF to count cell that contains a specific text within it. I will show both case-insensitive and ...

COUNTIF Partial Match (Couple of Easy Approaches)

COUNTIF is one of the most frequently used functions in Excel. A lot of tasks can be done using this function, one of them is the partial match. ...

VLOOKUP To Compare Two Lists (Same or Different Sheets)

Performing a comparison between a couple of lists is one of the familiar tasks in Excel. Today we are going to show how to compare two lists using ...

How to Count Duplicates in Excel (5 Methods)

While working with a large amount of data or compiling multiple worksheets into a bigger one, duplicate values, columns or rows may appear. Sometimes ...

How to Use VLOOKUP with COUNTIF (3 Ways)

VLOOKUP and COUNTIF are mostly used and powerful functions in MS Excel. VLOOKUP is used to find any specific data from any table and the COUNTIF ...

VLOOKUP Formula in Excel with Multiple Sheets (4 Simple Tips)

Today I will be showing how to use the VLOOKUP formula across multiple sheets in Excel. One of the most important and widely used functions of ...

VLOOKUP from Another Sheet in Excel

When you have to deal with massive data from multiple worksheets across your Excel workbook, the VLOOKUP function is your savior. The VLOOKUP ...

How to Use Excel IF Function with Range of Values

IF is one of the most useful and widely used functions of Excel. Today I will be showing how to use this IF function with a wide range of values, ...

ExcelDemy
Logo