Excel - How to Count Unique Values | Excel Tips 107

In this Excel tutorial, you will learn How to Count Unique Values | Excel Tips 107

Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book

Used formulas:
=SUMPRODUCT(1/COUNTIF(B2:B12;B2:B12))
=ROWS(UNIQUE(B2:B12))

--⏱️Timestamps⏱️--
00:00 | Count Unique Values in Legacy Excel
01:5 | Count Unique Values in Dynamic Array Excel
02:26 | The End


================
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube

You can also find me on:
📚Blog - https://excelandadam.com/
🍀Instagram -   / excelandadam  
🌟Tik Tok -   / excelandadam  
✨Facebook -   / excelandadam  
🕊Twitter -   / excelandadam  

#ExcelAndAdam #ExcelTips #excel