Filter unique, and then count

[Niccalo]

I need to write a formula that filters out unique numbers in one column lists them in another, and then counts the number of times each of those numbers appears in the original and lists the values next to them....I hope that meakes sense.

[CLR]

You might wish to consider the feature Tools > DataAnalysis > Histogram.....

Vaya con Dios,
Chuck, CABGx3



"Niccalo" wrote:

>
> I need to write a formula that filters out unique numbers in one column
> lists them in another, and then counts the number of times each of
> those numbers appears in the original and lists the values next to
> them....I hope that meakes sense.
>
>
> --
> Niccalo
> ------------------------------------------------------------------------
> Niccalo's Profile: http://www.excelforum.com/member.php...fo&userid=4344
> View this thread: http://www.excelforum.com/showthread...hreadid=553672
>
>

[JMB]

Another possibility is you can use Advanced Filter to get the unique records
(Data/Filter/Advanced Filter). Once you have the unique listing, check help
for the CountIf function to get the number of times each number appeared in
your original data.

I don't follow what you mean by "lists the values next to them."

"Niccalo" wrote:

>
> I need to write a formula that filters out unique numbers in one column
> lists them in another, and then counts the number of times each of
> those numbers appears in the original and lists the values next to
> them....I hope that meakes sense.
>
>
> --
> Niccalo
> ------------------------------------------------------------------------
> Niccalo's Profile: http://www.excelforum.com/member.php...fo&userid=4344
> View this thread: http://www.excelforum.com/showthread...hreadid=553672
>
>