COUNTIF Function

How to Count Duplicate Values Only Once in Excel (3 Ways)

In Excel, we need to perform various count operations, i.g. Count date occurrences, count text cells, count unique, counting duplicates, and many ...

How to Count Unique Names in Excel (5 Methods)

While working with large datasets we often may need to count unique and distinct values in excel.  Excel does not have any built-in function to count ...

How to Find Value In Range in Excel (3 Methods)

Circumstances may demand you to find value from a range. Finding, retrieving are common operations in Excel. Today we will show you how to find value ...

How to Create List from Range in Excel (3 Methods)

While working with a large database, you may need to create a list of data or text from the given database. If you do it manually, it will cost you a ...

How to Find If A Range of Cells Contains Specific Text in Excel (4 Methods)

While handling a large database you may need to find a specific text from the database. Excel has some functions by which you can easily do that. ...

Excel Search for Text in Range (11 Quick Methods)

In Microsoft Excel, there are numerous methods available to search for text in a range of cells or an array. You can search for a text value and ...

How to Find If Cell Contains Specific Text in Excel

In Excel, circumstances may demand checking whether a cell contains a specific text or not. Today we are going to show you how to check if a cell ...

How to Autofill Dates in Excel (3 Suitable Methods)

Today I will be showing how to autofill dates in Excel. While working in Excel, many a time we are to work with dates. We are to insert dates in a ...

How to Extract Data From Table Based on Multiple Criteria in Excel

Extracting the data on the time of necessity is the prime factor of using any spreadsheet, Excel is not an exception. You store data in tabular form ...

How to Create Dynamic List in Excel Based on Criteria (Single and Multiple Criteria)

Today I will be showing how to create a dynamic list based on single or multiple criteria in Excel. What is a Dynamic List In Excel? A ...

How to Generate List Based on Criteria in Excel (4 Methods)

In Excel, sometimes you may need to generate a list based on criteria. Today we are going to show you how to generate a list based on criteria. For ...

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 ...

ExcelDemy
Logo