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 Change Drop Down List Based on Cell Value in Excel (2 Ways)

In order to extract specific data based on specific values, we may need to use the drop-down list. Moreover, we need to co-relate the two or more ...

How to Extract Data Based on a Drop Down List Selection in Excel

To get a better visualization and comparison, we may need to extract some specific data based on certain criteria. In this article, we will show you ...

Excel Data Validation Drop Down List with Filter (2 Examples)

In this article, I will discuss how you can filter excel data using a Data Validation drop-down list. Usually, in Microsoft Excel, we use the Filter ...

How to Copy Filter Drop-Down List in Excel (5 Ways)

If you are trying to copy the filter drop-down list in Excel effectively, then this article is for you. Here, we will discuss different 5 ways for ...

How to Remove Duplicates from Drop Down List in Excel (4 Methods)

While working with a large Microsoft Excel dataset, sometimes we need to create a drop-down list and remove the duplicates from the drop-down list. ...

How to Select from Drop Down and Pull Data from Different Sheet in Excel

In this article, we will learn to select from the drop down and pull data from a different sheet in excel. Sometimes, we have a large dataset in a ...

Creating a Drop Down Filter to Extract Data Based on Selection in Excel

The Filter feature in Excel helps us to extract data according to our selections. But the problem with the feature is that the row numbers and the ...

How to Create a Drop Down List with Unique Values in Excel (4 Methods)

While working with categorical information in Excel i.e., products of different categories, you might need to create a drop-down list with unique ...

How to Count Unique Values in Filtered Column in Excel (5 Methods)

If you have a larger dataset and you need to apply filters in columns. More importantly, you might require to count only unique values except for the ...

How to Count Unique Values Based on Criteria in Another Column in Excel

If you are working on different categories of information in an Excel worksheet, you might need to find out and count all the unique values of 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 Use Advanced Filter for Unique Records Only in Excel

Daily, Excel users have to deal with duplicate entries in datasets. In that case, the Excel feature of Advanced Filter for unique records only is a ...

How to Count Only Visible Cells in Excel (5 Tricks)

Sometimes, In excel, we need to count only visible cells. For instance, when you apply a Filter to excel data, certain rows become hidden. Besides, ...

Errors in Excel and Their Meaning (15 Different Errors)

Every now and then, we bump into errors in the Excel datasheet. Whenever we input something wrong in the formula or function, Excel lets us know that ...

How to Copy Unique Values to Another Worksheet in Excel (5 Methods)

This article illustrates 5 different methods to copy unique values to another worksheet in the same workbook in Excel. Working with a dataset with ...

ExcelDemy
Logo