Ranking

[edwyn.mcfarlane]

I want to rank a list of number, but if the a number is the same as the previous row it should have the same rank. It should look like this:

e.g.

Number-----------------rank
900 --------------------1
777 -------------------- 2
384 -------------------- 3
111 -------------------- 4
111 -------------------- 4
100 -------------------- 6
97 -------------------- 7
97 -------------------- 7 (I can't quite figure out this bit)
97 -------------------- 7
4 -------------------- 10
2 -------------------- 11

I was trying in the rank column the following formula If(A2=A1,B2+frequency(A1:A11,A1),B2+1) but it doesn't seem to work.

Any suggestions would be extremely appreciated.

[NBVC]

Did you try using the RANK() function?

Try:

=RANK(A2,$A$2:$A$12)

copied down

where A2 is the first number to rank, and A2:A12 is your whole range reference to rank.. adjust as necessary