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