I found the following article:
http://support.microsoft.com/kb/213916
However i have a query. I have several identical sheets, each with an
identical layout but different data. I would like to rank all the data from
one column across all the sheets. Is there any way i can do this without
amalgamating the data onto one sheet? Is the formula in the link ammendable?
Thanks