ashley1984
New Member
- Joined
- Mar 31, 2018
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to sort a list of data where I can identify the top 10 sales by product group.
<tbody>
</tbody>
I am trying to sort a list of data where I can identify the top 10 sales by product group.
- I have several product groups A – E along with sales in each group.
- Each product group has over 10 sales recorded against each group
- I want to easily sort the top 10 sales in each product group
- Below is an example of what the data looks like.
- I want to sort the top 10 sales in each product group
Product | Sales |
PRODUCT A | £ 584,794 |
PRODUCT A | £ 388,073 |
PRODUCT A | £ 383,689 |
PRODUCT A | £ 342,863 |
PRODUCT A | £ 336,309 |
PRODUCT A | £ 307,654 |
PRODUCT A | £ 259,484 |
PRODUCT A | £ 225,525 |
PRODUCT A | £ 221,328 |
PRODUCT A | £ 220,059 |
PRODUCT A | £ 197,443 |
PRODUCT A | £ 195,582 |
PRODUCT A | £ 183,702 |
PRODUCT A | £ 183,231 |
PRODUCT A | £ 179,651 |
PRODUCT A | £ 175,929 |
PRODUCT A | £ 155,360 |
PRODUCT A | £ 152,893 |
PRODUCT A | £ 127,054 |
PRODUCT A | £ 124,859 |
PRODUCT B | £ 116,724 |
PRODUCT B | £ 106,979 |
PRODUCT B | £ 89,422 |
PRODUCT B | £ 74,994 |
PRODUCT B | £ 73,020 |
PRODUCT B | £ 72,481 |
PRODUCT B | £ 65,808 |
PRODUCT B | £ 65,540 |
PRODUCT B | £ 60,228 |
PRODUCT B | £ 57,010 |
PRODUCT B | £ 56,915 |
PRODUCT B | £ 45,120 |
PRODUCT B | £ 40,169 |
PRODUCT B | £ 32,320 |
PRODUCT B | £ 31,973 |
PRODUCT B | £ 31,502 |
PRODUCT B | £ 29,754 |
PRODUCT B | £ 27,215 |
PRODUCT B | £ 27,208 |
PRODUCT C | £ 24,680 |
PRODUCT C | £ 23,973 |
PRODUCT C | £ 22,342 |
PRODUCT C | £ 19,884 |
PRODUCT C | £ 19,060 |
PRODUCT C | £ 17,835 |
PRODUCT C | £ 14,913 |
PRODUCT C | £ 14,649 |
PRODUCT C | £ 13,778 |
PRODUCT C | £ 13,179 |
PRODUCT C | £ 12,318 |
PRODUCT C | £ 11,798 |
PRODUCT C | £ 9,469 |
PRODUCT C | £ 9,331 |
PRODUCT C | £ 8,157 |
PRODUCT C | £ 7,258 |
PRODUCT C | £ 6,676 |
PRODUCT C | £ 5,417 |
PRODUCT C | £ 4,034 |
PRODUCT C | £ 3,160 |
PRODUCT C | £ 2,817 |
PRODUCT C | £ 2,625 |
<tbody>
</tbody>