I'm not aware of a technique using a single worksheetfunction that can do that - I would write a
User-Defined-Function, or use multiple columns of formulas.
HTH,
Bernie
MS Excel MVP
"B. R.Ramachandran" wrote in message
...
Bernie,
This is a follow-up of my previous response.
If there is a tie, (e.g., banana, apple, banana, grapes), the formula would
rank them 2,1,2,and 4 respectively. I am curious, how you would modify the
formula to make grapes rank 3 (and not 4)?
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.
|