Hi,

Can someone help me with a formula to count unique items in a range (incl
blank cells) ?

Example,

A B C
1 xx zz yy
2 zz xx
3 qq xx

I would like to see the result of the formula as,

A B
1 qq 1
2 xx 3
3 yy 1
4 zz 2

I've tried all the combinations of Count and Frequency with no success.
Should I use another function ?

Thanks for your help in advance,

Thom