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