Filter unique, and then count

N

Niccalo

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
J

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