[absthechatter]

Originally Posted by TheNorm

Hmm...

There are some useful tips at the bottom of this page, together with a workbook that you can download (but I'm not sure this is what you want):

http://www.cpearson.com/excel/Rank.aspx

Thanks TheNorm, I had found that site whilst Googling, it does not show what I want though. Perhaps it's just not possible in Excel!! I will keep looking though.

Many thanks

Abs