Count # of unique occurances

S

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
 
B

bailfire13

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
 
B

Biff

Still have to count 'em!

Biff

bailfire13 said:
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
Click to expand...
 
Top