How to extract unique values through Excel formula?
To count the unique values from a list, we use the IF function along with the COUNTIF function in Microsoft Excel 2010.
IF: -The IF condition allows you to check for multiple conditions in a cell. It helps us to create the flexibility of the function in Microsoft Excel 2010 & 2013. Excel allows us to use upto 64 conditions which can be checked in a cell.
Syntax of IF function: =IF(logic_test, value_if_true, value_if_false)
COUNTIF: The COUNTIF function is used to count the number of cells in a range, which meet a given criteria.
Syntax of COUNTIF function: =COUNTIF(range, criteria)
Let’s consider an example to understand how to retrieve the unique list or unique count in Excel:-
Example 1: I have a list of color names in range A2:A8, in column B I want to extract a distinct list of color names.
Follow the below given steps:-
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.