How to Count Unique Values in Excel | How to Use the COUNTA and UNIQUE Functions

Опубликовано: 14 Сентябрь 2022
на канале: Excel, Word and PowerPoint Tutorials from Howtech

72,552

193

In this video, we’ll show you How to Count Unique Values in Excel.

Microsoft Excel has a lot of useful functions, but today we’ll show you how to calculate unique values and their quantity.

Let’s go through the steps!

Open your spreadsheet.
Let’s suppose that we have a set of values entered in cells A1 through A5.
Use this formula to find out all the unique values:
=UNIQUE(A1:A5) and press the enter button.
You will see all the unique values.
Now if you want to find out the total number of unique values, then use this formula.
=COUNTA(UNIQUE(A1:A5)) and press enter.
Now you can see all the unique values in your list.

That’s it!

❓💬 What other tips do you want to know? Let us know in the comments below.

#HowTech #excel
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here https://t.me/howtechtv
✅ Commercial questions [email protected]
✅ Facebook   / howtechtv
✅ Instagram   / howtechprojects
✅ Twitter   / howtechprojects