What are other syntax to count unique records?

[Rev12]

Hi Everyone!

I have the formula below that counts unique records the only thing is it slower my file.

=Sumproduct(1/CountIf(B5:B10000,B5:B10000&"")

Is there any other syntax that I could use to count records aside of the one above?


Thanks in advance,
Rev12

 

[Aladin Akyurek]

Assuming that B5:B10000 is not entirely numeric...

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF(1-(B5:B10000=""),MATCH(B5:B10000,B5:B10000,0)),ROW(B5:B10000)-ROW(B5)+1),1))