Excel Filtering

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
 
G

Guest

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
 
Top