Count # of unique occurances

[sharder]

I have a list that show mulitple times in my spreedsheet and I need t
know how many actual numbers are there Ex: I actually have 5 order
here.
398805
398805
398805
516878
516878
516878
540836
540836
540836
540836
540836
567585
567585
567585
567585
567911
567911
567911
567911
Thanks for your hel

 

[Biff]

Hi!

Try this:

=SUMPRODUCT((A1:A19<>"")/COUNTIF(A1:A19,A1:A19&""))

Biff

 

[Guest]

Go into Data, go to Filter, go to Advanced Filter. There, you can select
Unique Records Only, and either sort it in place or copy to another location.

Bailfire13

 

[Biff]

Still have to count 'em!

Biff

Go into Data, go to Filter, go to Advanced Filter. There, you can select
Unique Records Only, and either sort it in place or copy to another
location.

Bailfire13