Count # of unique occurances

[sharder]

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

[Biff]

Hi!

Try this:

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

Biff

"sharder" <[email protected]> wrote in
message news:[email protected]...
>
> I have a list that show mulitple times in my spreedsheet and I need to
> know how many actual numbers are there Ex: I actually have 5 orders
> here.
> 398805
> 398805
> 398805
> 516878
> 516878
> 516878
> 540836
> 540836
> 540836
> 540836
> 540836
> 567585
> 567585
> 567585
> 567585
> 567911
> 567911
> 567911
> 567911
> Thanks for your help
>
>
> --
> sharder
> ------------------------------------------------------------------------
> sharder's Profile:
> http://www.excelforum.com/member.php...o&userid=25488
> View this thread: http://www.excelforum.com/showthread...hreadid=556605
>

[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


"sharder" wrote:

>
> I have a list that show mulitple times in my spreedsheet and I need to
> know how many actual numbers are there Ex: I actually have 5 orders
> here.
> 398805
> 398805
> 398805
> 516878
> 516878
> 516878
> 540836
> 540836
> 540836
> 540836
> 540836
> 567585
> 567585
> 567585
> 567585
> 567911
> 567911
> 567911
> 567911
> Thanks for your help
>
>
> --
> sharder
> ------------------------------------------------------------------------
> sharder's Profile: http://www.excelforum.com/member.php...o&userid=25488
> View this thread: http://www.excelforum.com/showthread...hreadid=556605
>
>

[Biff]

Still have to count 'em!

Biff

"bailfire13" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
> "sharder" wrote:
>
>>
>> I have a list that show mulitple times in my spreedsheet and I need to
>> know how many actual numbers are there Ex: I actually have 5 orders
>> here.
>> 398805
>> 398805
>> 398805
>> 516878
>> 516878
>> 516878
>> 540836
>> 540836
>> 540836
>> 540836
>> 540836
>> 567585
>> 567585
>> 567585
>> 567585
>> 567911
>> 567911
>> 567911
>> 567911
>> Thanks for your help
>>
>>
>> --
>> sharder
>> ------------------------------------------------------------------------
>> sharder's Profile:
>> http://www.excelforum.com/member.php...o&userid=25488
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=556605
>>
>>