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

How do I track frequency of occurance in data table?
 

You can do it as a pivot table. Create a pivot table of your data (Data -
Pivot Table follow the wizard). Place the product code in the left hand
column and also in the middle. You should now have a count of all of your
product codes. In the field settings for the product code you can sort
descending by the count of Product Code. This will only work if you have
8,000 or less product codes. If this won't work for you then the solution
gets trickier.
--
HTH...

Jim Thomlinson


"Rowe280" wrote:

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