How do I track frequency of occurance in data table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

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

Detect String Frequency on dynamic entries 4
array frequency data search 1
Data search problem 2
Track Maximum occurences in Array 4
Tracking High Frequency Occurences 4
Sort worksheet by the number of occurances 3
Frequency of time range in two columns? 3
Access Updating inventory levels 0

Back
Top