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

Published: 14 September 2022
on channel: 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

Watch video How to Count Unique Values in Excel | How to Use the COUNTA and UNIQUE Functions online, duration hours minute second in high quality that is uploaded to the channel Excel, Word and PowerPoint Tutorials from Howtech 14 September 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 72,552 times and liked it 193 visitors.

3,703,720

47K