Help with Excel!

[mcguire88]

Hi, I need help with Excel to use a formula that I need.

What I need the formula to do is basically give a 'place' to scores that I have placed in one column. For example if I have:

275
200
250
300
189

I want the column next to this one to read:

2
4
3
1
5

Can anyone help me with the formula I need to use for this?? And explain what to do it for it?

Thanks!

[Machecoul]

The formula uses RANK as a function.

Assume 275 in b1, 200 in b2, 250 in b3 etc. - b1:b5 i.e in cells b1 to b5

Assume you want answers in c1, c2, c3 etc.

in c1 type =rank(b1,$b$1:$b$5) and then copy and paste this into the rest of column c.

Putting the $ sign in keeps the b1:b5 array from changing and incrementing and only changes the first b1, to b2, b3 etc

Hope this makes sense.

[Machecoul]

Thanks for this - I didn't know how to do this before either!! Could be quite useful.

In Excel i went to INSERT and selected FUNCTIONS and then had a look for RANK which sounded like a useful word to describe what you wanted and there it was. Just played around with it.

[mcguire88]

Thanks so much! Worked perfectly!