Hi Folks,

I've received some amazing help a few days ago so I figured this would be a good place to expose my new problem.

I have attached a mock version of what I'm trying to achieve. Basically, I'd like to sort a table only based on formulas and disregard the shipment number field. I assume the "volume" column will need an index&match formula to capture the info (based on supplier name and date) but cannot workout how to get the sorting done first.

Any thoughts from another excel genius :-)?

Thanks!

SubExample sorting table.xls