Using Rank function for 2 or more ranges

[clive branson]

I am have created a set of Rugby World Cup Results Tables in Excel XP.
I have used the Rank Function to calculate how each team is ranked in
each league based on a range of cells which show league points gained.
ie =Rank(Ref(league points gained), range(league points gained by all
teams), 0). This calculates that more than one team may be 1st, 2nd or
3rd etc. I now want to modify the expression to automatically
calculate their Ranking by a second range of cells which shows their
Game Points Difference. Can you suggest how I can do this in one
expression.

 

[Bob Phillips]

Clive,

As you are testing for two criteria, it is best to set-up a new column with
the concatenated values in, and rank on that column.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)