Excel Filtering

  • Thread starter Thread starter oa6n
  • Start date Start date
O

oa6n

Is it possible to filter data in excel based on frequency. For example
I have a list of ID numbers that show up multiple times I would like t
sort the list by the ID numbers that show up the most often. I woul
also like to sort the data so that I can see the Id numbers that com
up most often and with the highest dollar amount owed
 
Add a column to your list. Insert a formula using COUNTIF
on the entire ID column that shows the count of that ID
number. Then filter the list on the count column for.
Good luck
 
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

Custom Sort of Filter? 5
Excel 2003 Filtering Mistery 8
Excel finding top of range 1
Sorting/Filtering Info 2
Using Filter more than once 2
Excel Query setup 0
Hold conditional formatting when sorting filtered data 1
Retrieve data with MAX and VLOOKUP 1

Back
Top