How to Count Unique Values in Excel | How to Use the COUNTA and UNIQUE Functions
on channel: Excel, Word and PowerPoint Tutorials from Howtech
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 without registration, duration hours minute second in high quality. This video was added by user Excel, Word and PowerPoint Tutorials from Howtech 14 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 72,552 once and liked it 193 people.