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
 
Back
Top