Hi Paul,

thank you for your reply! I am looking at sports rankings where they count wins, draws or losses.

The best city would be the city with the most wins?

I am working on a sample workbook with my macro that creates the output, I will post it as soon as I get it more complete.