Filter unique, and then count

  • Thread starter Thread starter Niccalo
  • Start date Start date
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
 
You might wish to consider the feature Tools > DataAnalysis > Histogram.....

Vaya con Dios,
Chuck, CABGx3
 
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."
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count unique values with auto-filter on 6
need help on either doing a loop and counting specific values orusing subtotal function 2
customer Name against Unique customer number count 3
Count Unique Values but not Filtered or Hidden Values 3
Count Unique accross mulitple columns 3
Count unique with multiple criteria 3
count unique values in a filtered range 2
counting unique items(values or text) 14

Back
Top