Ranking data

[LiAD]

maybe this will have a very similar solution to my first question.

If I have a range of data such as below which i want excel to tell me which
is the biggest and call it 1st, the second biggest 2nd etc.

inputs ouput
a 3 3rd
b 6 1st
c 1 4th
d 4 2nd

I do not know yet how long my list of data will be, somehwere between 6 and
10 rows i guess so its not much.

Any ideas on this one as well?

Thanks

 

[Stefi]

=RANK(B2,B:B)

and fill it down!

Regards,
Stefi

„LiAD†ezt írta:

 

[LiAD]

thanks a million

so simple when u know how

u've solved my first question with that too.

thanks

 

[Shane Devenshire]

Hi,

I think it takes a little more work to reach your requested results "1st,
2nd, 3rd"....

Suppose your data is in column A

1. In cell E1 enter 1st and fill it down 10 or more rows.
2. In cell D1 enter 1 and in D2 enter 2. Highlight both of these and
double-click the fill handle
3. In B1 enter the formula
=VLOOKUP(RANK(A1,$A$1:$A$8),$D$1:$E$10,2,FALSE)
and fill it down.