Sorting on 2 values
Hi ,
I made the document I enclosed, but I wanna have in the sheet "2nd round and
finals" to be filled in automatically.
First is to see who is the fist in the specific group (most points) and when
2 or more teams has the same amount of points, then the aggregate is
important (highest).
I know how to rank and vlookup for the first points (the points) but how
further?
Thanks for your help!
Regards,
Colin
|