Sorting data by product group

Status
Not open for further replies.

ashley1984

New Member
Joined
Mar 31, 2018
Messages
32
Office Version
  1. 365
Platform
  1. Windows
Hi,
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

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>
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Duplicate https://www.mrexcel.com/forum/excel-questions/1049938-sorting-data-product-group.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top