Sorting Question

[Ginger5]

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>

 

[pgc01]

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.

 

[Ginger5]

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!