formula for counting unique record

[polska2180]

Okay, I haven't been able to find this anywhere but I need a formula to count unique records....kinda like with you do a adv. filter and do unique records. But reather then me doing it on every sheet I have I would like a formula. The row I interested is filled with account numbers so:

12324
12324
12554
35758
35412
35412

So this would give a total of 4 unique records....thanks for any help.

 

[Aladin Akyurek]

Okay, I haven't been able to find this anywhere but I need a formula to count unique records....kinda like with you do a adv. filter and do unique records. But reather then me doing it on every sheet I have I would like a formula. The row I interested is filled with account numbers so:

12324
12324
12554
35758
35412
35412

So this would give a total of 4 unique records....thanks for any help.

One of:

1]

=SUM(IF(A2:A7<>"",1/COUNTIF(A2:A7,A2:A7)))

which needs to be confirmed with control+shift+enter.

2]

=SUMPRODUCT((A2:A7<>"")/COUNTIF(A2:A7,A2:A7))

3] If A2:A7 is numeric...

=SUM(IF(FREQUENCY(A2:A7,A2:A7)>0,1))

 

[Greg Truby]

Oh - Aladin gave us a bonus option versus what he offered up here.

 

[polska2180]

Thanks