Sort multimple columns and criteria using formulas only.

Hi all, Iīm trying to sort a table based on two values using only formulas, I found a very tidy solution for using single criteria in this post, nice work there!

I would like to further construct on this solution to encompass two criterias, in the attached file you can see a sample list. Basically I would like to sort first for width (w), and then sort for height (h), I can see thereīs a way to expand/nest the formulas provided on the above thread, I just canīt get my head around it...

Thanks for your help!

cheers
saurjusa

I may have solve this using rank.eq.
For the current example it yields the expected results.
Hopefully this is valida for the working document. you can see my solution in the attachment...

cheers,
saurjusa

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

I have done it for you this time.