need a formula or macro for excel to return top 3 values based on certain categories.

I have a sheet with fruit shipments going out of a warehouse. I need to find out the top 3 sizes that went out based on the grower (column G) the variety(column I) the shipment category (column J) column G has different grower names as well as column I and J. I need it to group all all the rows of a specific grower then group its varieties, the shipment category and tell me what top 3 sizes (column L) that went out based on weights (column M)

whats is the best way to go about this? i simply havent been able to wrap my mind around it

You can use pivot table for this and very easy.

For row table: Grower (column G), Variety (column I)
For Values : Size (J) and set values setting into max

After the result has been show, at values filter choose top 10...
choose : Top, enter 3, Choose: Item or Percent or Sum, and by Max Size

Regards
SDCh

i had already tried a pivor table but it wont give me the information that i am looking for. Capture.PNG if you look at the picture it might be easyer to understand. i need to be sort the top 3 sizes shiped out by the following categories. picture example: grower G0207 variety GAL in early pool had sizes 100, 88, 113 shiped out the most. because it had the most wight ship out (size 100 was 1368 lbs, 88 was 1223 lbs and 113 was 1106 lbs) each grower has multiple varieties and those varieties go in diferent pool (early, late + pool, mid tem CA, Non Owned, Regular. and each pool has 3 top sizes shiped out based on weight. in addition there are multiple growers.

If you don't mind with little trick, hope this can help. If not may be other member can help.

Regards,
SDCh

Thank you this worked great!