Ranking Data from Multiple Worksheets

[lukela85]

Hi,

I am not sure if you can do this, but what I would like to do is rank data from a range of worksheets, so.....

An example

I would like to calculate the rank of the data in Sheet 1 Cell A1, against the data held in Sheet 2 Cell A1 and Sheet 3 Cell A1.

Is this possible?

Any help would be greatly appreciated.

Thanks,

Luke

[martindwilson]

just reference them in another range so say in g1 put =c1 in g2 =sheet2!c1 g3=sheet2!c1 then rank that

[WHER]

Or, on Sheet1:
=RANK(A1,Sheet1:Sheet3!A1)