View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rowe280 Rowe280 is offline
external usenet poster
 
Posts: 1
Default How do I track frequency of occurance in data table?

I have a list of transactions containing part numbers. I need to find out
what part numbers occur the most in the table. I can sort the results, but I
really need the list in order of the most frequently occuring to least
frequently occuring values. The other option would be to get this data from
a report in excel or access I guess. Any suggestions for tracking most
frequently used items from a long transaction log?

Thanks