Excel: How to Count Unique Values Without Using a Pivot Table

[@MikeThomas67]

Download a free copy of the file used in this video: theexceltrainer.co.uk/excel-count-unique-values-without-using-a-pivot-table/

[@Jennifer_J_C]

Thanks Mike 😊

[@pandamonium9834]

Clever stuff Mike and thank you 😀

[@kkravch]

Nice video Mike. On a different note... I know on small models it does not matter, but recently I watched a video about comparing sort(unique()) vs unique(sort()) and it looks like if one sorts before applies unique, the model runs much faster.

[@sscire]

This is another solution with the GROUPBY function:
=GROUPBY(C2:C13,B2:B13,LAMBDA(x,y,COUNTA(UNIQUE(x))),0,0)

[@MikeThomas67]

Thanks for sharing!