Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

UNIQUE Function

How to Filter Duplicates in Excel (7 Suitable Ways)

If you are looking for the easiest ways to filter duplicates in Excel then you are in the right place. You can get a clear concept of filtering ...

How to Use Formula to Automatically Remove Duplicates in Excel

One of the most important and widely used activities in Excel is the removal of duplicate values from a data set. Today I’ll show 6 easy ways to use ...

COUNTIFS Unique Values in Excel (4 Easy Ways)

While working in Excel, we often have to sort out the unique values from a set of data. Sometimes we have to count the number of equal values in a ...

How to Count Unique Values Using Excel Pivot Table (3 Ways)

Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can perform tedious operations like counting text cells, ...

How to Count Unique Names in Excel (6 Simple 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 Create List from Range in Excel (4 Easy Ways)

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 Combine Row into One Cell in Excel

Today I will be showing how to combine rows into one cell in Excel. While working in Excel, trying to combine rows or columns is one of the most ...

Excel Dependent Drop Down List (Create with Easy Steps)

Up till now, we have learned to create drop-down lists in Excel. Today I will be showing how you to create a dependent drop down list in Excel. ...

How to Create Dynamic List in Excel Based on Criteria (3 Ways)

Today I will be showing how to create a dynamic list based on single or multiple criteria in Excel. Download Practice Workbook Dynamic ...

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 Populate a List Based on Cell Value in Excel

In Microsoft Excel, sometimes we may need to determine or find values based on some criteria or condition from a list. It is not an impossible task ...

Conditional Drop Down List in Excel (Create, Sort and Use)

In Microsoft Excel, the applications of the conditional or dependent drop-down list are immense in the field of data analysis. And creating this ...

How to Create Dynamic Dependent Drop Down List in Excel

Today I will be showing how you can create a dynamic dependent drop down list in Excel using both Formulas and Tables. Download Practice ...

How to Get Top 10 Values Based on Criteria in Excel

In many cases, we may want to find the top values which satisfy one or more conditions from an Excel dataset. There are plenty of Excel functions to ...

How to Return Multiple Values Based on Single Criteria in Excel

If you are looking for Excel to return multiple values based on single criteria, then you are in the right place. While using Excel, finding multiple ...