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