COUNTIF Function

How to Create Leave Tracker in Excel (Download Free Template)

Leave tracker is a widely used task for the human resource department to track every people for their vacation and working days. Almost every ...

Hide Duplicate Rows Based on One Column in Excel (4 Methods)

Hiding duplicate rows are one of the most frequent tasks that we need to do in Excel. In this article, you will learn 4 methods to hide duplicate ...

How to Create an Auto Ranking Table in Excel (with Quick Steps)

An auto ranking table can rank data based on ascending or descending order using a formula. In this article, you will learn to create an auto ranking ...

How to Create a Ranking Graph in Excel (5 Methods)

This article illustrates how to create a ranking graph in excel. A ranking graph can be very helpful to keep track of the performances of your ...

Excel INDEX-MATCH Formula to Return Multiple Values Horizontally

We can search match objects in Excel in different ways. There are different Excel functions, VBA codes are used to find the matching and return them. ...

How to Highlight Duplicates in Multiple Columns in Excel (4 Ways)

When we deal with a large Excel spreadsheet, duplicate values trapped in our dataset often. Or sometimes it becomes required for us to find them for ...

How to Make a Random Selection from List Without Repetition in Excel

If you are looking for some special tricks to make a random selection from a list without repetition in Excel, you've come to the right place. In ...

How to Find Duplicate Values in Excel Using Formula (9 Methods)

This article illustrates how to find duplicate values in excel using a  formula. It will be very tedious if you try to find duplicate values manually ...

How to Highlight Duplicates in Two Columns Using Excel Formula

If you are looking for some special tricks to highlight duplicates in two columns using the Excel formula, you've come to the right place. In ...

Return YES If 2 Cells Match in Excel (10 Methods)

We can compare two cells in MS Excel in different ways. Excel offers many easy methods to compare two cells and return a certain value if the values ...

Create a Searchable Drop Down List in Excel (2 Methods)

This article illustrates how to create a searchable drop-down list in excel. It shows the 2 ways you can do that in excel using formulas and VBA. The ...

Count Unique Text Values with Criteria in Excel (5 Methods)

This article illustrates 5 methods on how to count unique text values with criteria in excel. You may need to extract customer names who appear ...

How to Create a Dynamic Top 10 List in Excel (8 Methods)

A top list is used to rank the companies or individuals based on values. This rank is set based on performance, quality, etc., or other criteria. In ...

VBA to Count Blank Cells in Range in Excel (3 Methods)

When we have a large amount of data in our Excel worksheet, it is easier if we have the knowledge of the total counts of certain ranges of the sheet. ...

How to Count Repeated Words in Excel (11 Methods)

In Microsoft Excel, we work with a large amount of data. In a large datasheet, usually, we see some repeated words. It is tiresome to find out those ...

ExcelDemy
Logo