Bernie,
The formula you have suggested is extremely elegant (in the way it works).
Regards,
B. R. Ramachandran
"Bernie Deitrick" wrote:
You could simply sort the column ascending.
If your values are in a1:a5, then the formula
=SUMPRODUCT((A1$A$1:$A$5)*1)+1
copied down for 5 rows will give the ranking.
--
HTH,
Bernie
MS Excel MVP
"cdavidson" wrote in message
...
I'll use a simple example...
I have 5 words I need to rank in ascending order, alphabetically.
Carrot
Peach
Apple
Salad
Banana
I would like the rank function to produce the following results:
Rank Name
------ -------
1 Apple
2 Banana
3 Carrot
4 Peach
5 Salad
How please? Many thanks.
|