Filter unique, and then count

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Niccalo - 20 Jun 2006 16:13 GMT

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

Reply to this Message

CLR - 20 Jun 2006 16:37 GMT

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

Vaya con Dios,
Chuck, CABGx3

> 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.

Reply to this Message

JMB - 21 Jun 2006 04:09 GMT

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."

Reply to this Message