Filtering the top 25 values in a column

**Lou54** · 08-09-2012, 08:24 AM

Hello kind folks.I'm trying to find a way of getting a list of the top 25 entries based on the number of times they appear in a column.And how many times they appear.I've been able to count the number of times a value appears in the column but this could take a long while as there are 100's of different entries in the column.Sort out duplicates and so on but I havent been able to find a way to filter or sort or count my way to what I need.As always your help and kindness are greatly appreciated.

**NBVC** · 08-09-2012, 08:31 AM

What formula did you use to count?

something like:

=COUNTIF(C:C,C2) copied down based on column C being of interest.

Then you can filter, by selecting Number Filters, then Top 10... (and change to 25).

**Lou54** · 08-09-2012, 02:45 PM

Thanks NBVC,but when I used the =Countif(E:E,E2) and copied that down to the bottom of the column I wanted to sort,It put a zero in every cell for some reason.I used the Countif formula then gave it a one of the part numbers I was looking for, this worked,in a way but there are 344 different part numbers in the well over 3k length of the column.Im trying to find the 25 most made parts in the last calender year,and the number of times we made each of them.I hope this helps to better explain what Im trying to do here.Thanks for your help....Lou

**NBVC** · 08-09-2012, 02:48 PM

I can't see how =Countif(E:E,E2) gives you 0 unless there is nothing in E2

You should get a 1... then the second match will have 2, etc...

**Lou54** · 08-09-2012, 03:29 PM

Thanks for your help NBVC

**NBVC** · 08-09-2012, 03:40 PM

Does this mean it works?

**FDibbins** · 08-09-2012, 03:46 PM

magic smagic?

**Lou54** · 08-09-2012, 04:01 PM

Im sorry but I cant get it to work.The cell E810 is where last Aug 8th is started so I changed the formula to read...=Countif(E:E,E810) and put the code in a cell above E810 and still have the same results.Im problaby doing something wrong but I'll get a freash start in the morning.I do appreciate all the help.....lou

**NBVC** · 08-09-2012, 04:02 PM

The formula doesn't go in column E.. it goes in the next available empty column.... then copy it down... and use that column for filtering top 25..

If you still can't get it, post a sample workbook with no confidential info in it.

**Lou54** · 08-10-2012, 08:59 AM

Thanks NBVC,and please excuse my ignorance.It worked like a charm.Now I can filter those and find the info I needed.Again many thanks for your time.....Lou