UNIQUE Function

8 Ways to Count Duplicate Values in Multiple Columns in Excel

Microsoft Excel is the most useful data-tracking software. For datasets that have numerous worksheets or users or identity numbers, it is difficult ...

4 Steps to Count Rows in Group Using Pivot Table in Excel

In this lesson, I'll demonstrate these approaches to use Pivot Table to Count Rows in a Group in Excel. Moreover, these techniques will enable you to ...

3 Ways to VLOOKUP Multiple Values in One Cell in Excel

In this lesson, I'll demonstrate 3 effective approaches to VLOOKUP Multiple Values in One Cell in Excel. Moreover, these techniques will enable you ...

4 Ways to Remove Duplicates from Drop-Down List in Excel

Duplicate Values appear often in our workbook. If we want to make drop-down list based on a column that contains duplicates, all the values will ...

5 Ways to Copy Unique Values to Another Worksheet in Excel

Sometimes we get datasheets with many duplicate values and we have to extract the unique values removing the duplicates. In this article, we will ...

8 Ways to Create a Unique List Based on Criteria in Excel

Maybe you have a list of repeating data that you want to sort. In Excel, you can actually make a unique list based on criteria. However, this is only ...

3 Ways to Create Dynamic List Based on Criteria in Excel

Sometimes we need to create a Dynamic List in Excel to perform various operations or just to show the values that match the conditions. In this ...

7 Easy Ways to Populate List Based on Cell Value in Excel

In some cases, we need to populate list based on cell value in Excel. Like, suppose you have a dataset of sales of the previous year. Suppose you ...

How to Extract Unique Values Based on Criteria in Excel

We live in an age of information revolution. Lots of data is taking place every day. The greatest challenge is to extract particular data for ...

ExcelDen
Logo