# Sorting Question

#### Ginger5

##### New Member
I have about 5000 organizations listed alphabetically. Some organizations are listed more than once-depending on the number of times that have used our company. I need to sort by the top 200 sales average, but within the top 200 if the company is listed more than once I need to show their additional rows of data underneath their top earning sales average, so we can see their other sales averages as well as their top #. Is this possible? Thanks!!!

I need it to look like
 Company Name Sales Average Lily's \$500 Lily's \$200 Lily's \$100 Ernie's \$400 Ernie's \$100 Cal's \$50 Cal's \$50

<tbody>
</tbody>

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Hi
Welcome to the board

Add an auxilliary column with the total of each company. Then sort using first the total, then the sales average.

How can I pull the top 200 sales averages out of about 5000 averages, but also show if that company (that has a top 200 sales avg) has other sales averages as well? Some companies have used us several times, so they have a separate row of data for each time they have used us. I need to show each time they have used us. Thank you!

Replies
1
Views
833
Replies
1
Views
674
Replies
10
Views
6K
Replies
2
Views
204
Replies
1
Views
284

1,203,242
Messages
6,054,354
Members
444,718
Latest member
r0nster

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

### Which adblocker are you using?

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

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