Sorting by Usage then Item ID Based on Location

[jalouw]

I have a spread sheet that has usage numbers for items based on location of the item being used. I have to sort the spreadsheet to give me the item that has the highest usage for the past 90 days, but then gives me the item ID information for the other branches associated with it. Currently when I sort, it gives me 90 day usage ranked largest to smallest. I want This ranked by usage, then by location. I have given a sample of what I'm getting when I sort. The H2C has usage associated with it at other locations. I want all the 10009513-C and all the usage associated with it at other branches at the top, and so on and so forth going on down.

[TABLE="width: 749"]
<tbody>[TR]
[TD="class: xl63, width: 155"]Item ID[/TD]
[TD="class: xl63, width: 169"]Item Desc[/TD]
[TD="class: xl63, width: 62"]Location ID[/TD]
[TD="class: xl64, width: 98"]Qty On Hand[/TD]
[TD="class: xl64, width: 74"]Minimum[/TD]
[TD="class: xl64, width: 74"]Maximum[/TD]
[TD="class: xl64, width: 117"]Last 90 Day Usage[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 749"]
<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]10009513 -C[/TD]
[TD]RGX-N-05-986 MALE NIPPLE[/TD]
[TD]580[/TD]
[TD="align: right"]112.00[/TD]
[TD="align: right"]1,120.00[/TD]
[TD="align: right"]2,240.00[/TD]
[TD="align: right"]11,191.00[/TD]
[/TR]
[TR]
[TD]B20-5B-BULK[/TD]
[TD]COUPLER (BP) |P100N[/TD]
[TD]580[/TD]
[TD="align: right"]1,200.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]2,300.00[/TD]
[/TR]
[TR]
[TD]PS6905JM-6-6[/TD]
[TD]SWIVEL ASSY |P5YB1[/TD]
[TD]545[/TD]
[TD="align: right"]514.00[/TD]
[TD="align: right"]625.00[/TD]
[TD="align: right"]750.00[/TD]
[TD="align: right"]1,100.00[/TD]
[/TR]
[TR]
[TD]PC306-BP[/TD]
[TD]NON-VALVED COUPLER |P5NB100[/TD]
[TD]585[/TD]
[TD="align: right"]99.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]20.00[/TD]
[TD="align: right"]690.00[/TD]
[/TR]
[TR]
[TD]PN353[/TD]
[TD]NON-VALVED NIPPLE |P20NB250[/TD]
[TD]585[/TD]
[TD="align: right"]180.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]30.00[/TD]
[TD="align: right"]654.00[/TD]
[/TR]
[TR]
[TD]EZ-251-6MP[/TD]
[TD]COUPLER (OLD # EZ304M-6T) (IL) |P10YB1[/TD]
[TD]545[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]550.00[/TD]
[/TR]
[TR]
[TD]SST-N3M[/TD]
[TD]NON-VALVED NIPPLE |P5YB1[/TD]
[TD]583[/TD]
[TD="align: right"]103.00[/TD]
[TD="align: right"]20.00[/TD]
[TD="align: right"]100.00[/TD]
[TD="align: right"]500.00[/TD]
[/TR]
[TR]
[TD]H2C[/TD]
[TD]NON-VALVED NIPPLE |P20NB200[/TD]
[TD]585[/TD]
[TD="align: right"]293.00[/TD]
[TD="align: right"]200.00[/TD]
[TD="align: right"]300.00[/TD]
[TD="align: right"]453.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[SpillerBD]

Use the multi-sort feature.
https://support.office.com/en-us/ar...or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654

 

[jalouw]

I've tried that and it didn't work. It will group the highest usage items together. I need to group by usage then item ID.