wrote in message
oups.com...
Funny to me that the formula I provided intitally does not work (it
was provided by chip pearson)..any explanations? (I have the ranking
fornula in the column to the left of the data and the data is not in
any order..)

No I con't explain why your original formula did not work for you. The
RANK() funtion will return ties but the COUNTIF() function will add an
asscending number to it to prevent the same number being returned by the
formula. This will happen even if the *numbers* are actually text.

Anyway I'm glad that you got a formula that works for you.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk