I would like to create a top 10 list without using a pivot table.
On sheet 1 there will be data that is added to daily. Below is an example of the data.
Then on sheet 2 I would like to add a section that has a top 10 list. As data is entered on sheet 1, I would like the list to update and change accordingly.
From sheet 1 looking at Column D (item #) it just needs to count how many times the item shows up in the data and rank it accordingly.
So from the data example above it would be as follows
1. Item 3000 shows 4 times
2. item 422878 shows 3 times
etc
On sheet 1 there will be data that is added to daily. Below is an example of the data.
Then on sheet 2 I would like to add a section that has a top 10 list. As data is entered on sheet 1, I would like the list to update and change accordingly.
From sheet 1 looking at Column D (item #) it just needs to count how many times the item shows up in the data and rank it accordingly.
So from the data example above it would be as follows
1. Item 3000 shows 4 times
2. item 422878 shows 3 times
etc