Excel formula for Beginners – How to find Unique values in Excel

Hits: 33

 

(Excel examples for Beginners)

In this end-to-end excel example, you will learn – Excel formula for Beginners – How to find Unique values in Excel.

 

Excel formula for Beginners – How to find Unique values in Excel

Generic formula

=UNIQUE(data)

Summary

To extract a list of unique values from a set of data, you can use the UNIQUE function. In the example shown, the formula in D5 is:

=UNIQUE(B5:B16)

which outputs the 7 unique values seen in D5:D11.

Explanation

This example uses the UNIQUE function, which is fully automatic. When UNIQUE is provided with the range B5:B16, which contains 12 values, it returns the 7 unique values seen in D5:D11.

UNIQUE is a dynamic function. If any data in B5:B16 changes, the output from UNIQUE will update immediately.

Dynamic source range

UNIQUE won’t automatically adjust the source range if data is added or deleted. To feed UNIQUE a dynamic range that will automatically resize as needed, you can use an Excel Table, or create a dynamic named range with a formula.

 

 

Sign up to get end-to-end “Learn By Coding” example.


 

 

Introduction to Applied Machine Learning & Data Science for Beginners, Business Analysts, Students, Researchers and Freelancers with Python & R Codes @ Western Australian Center for Applied Machine Learning & Data Science (WACAMLDS) !!!

Latest end-to-end Learn by Coding Projects (Jupyter Notebooks) in Python and R:

Applied Statistics with R for Beginners and Business Professionals

Data Science and Machine Learning Projects in Python: Tabular Data Analytics

Data Science and Machine Learning Projects in R: Tabular Data Analytics

Python Machine Learning & Data Science Recipes: Learn by Coding

R Machine Learning & Data Science Recipes: Learn by Coding