UNIQUE Function Archives - Page 3 of 6

UNIQUE Function

How to Change Drop Down List Based on Cell Value in Excel (2 Ways)

Sep 8, 2022 Advanced Excel 2

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

Sep 8, 2022 Advanced 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)

Aug 8, 2022 Advanced Excel

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)

May 26, 2022 Advanced Excel

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)

May 26, 2022 Advanced Excel

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

May 26, 2022 Advanced 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

May 26, 2022 Advanced 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)

May 26, 2022 Advanced Excel

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)

May 26, 2022 Excel Formulas 3

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

May 26, 2022 Excel Formulas

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)

Apr 9, 2022 Excel Formulas

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

May 25, 2022 Advanced 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)

Jan 26, 2023 Excel Formulas

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)

Jan 8, 2023 Excel Basics

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)

Sep 14, 2022 Excel Basics

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