Excel - How to Count Unique Values with condition | Excel Tips 108
In this Excel tutorial, you will learn How to Count Unique Values with condition | Excel Tips 108
Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book
Used formula:
=SUMPRODUCT( ($B$2:$B$12=F1)/COUNTIF($C$2:$C$12,$C$2:$C$12))
=ROWS(UNIQUE(FILTER($C$2:$C$12,$B$2:$B$12=F1)))
--⏱️Timestamps⏱️--
00:00 | Count Unique Values with condtion in Legacy Excel
04:36 | Count Unique Values with condtion in Dynamic Array Excel
06:08 | 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