Rank columns based on value in another column

D

duketter

Excel 2007 - I have a worksheet where column B is filled with random scores.
In column C I would like to have the corresponding score in column B ranked
against all the other scores in column B so it would rank each of the scores
between 1-10.

Example:
Column B Column C
9.56 2
10.12 1
8.11 4
8.99 3
etc.

If the value in column B changes (it sometimes does) then all the ranks in
column C should adjust accordingly. Is this possible?

Thanks!
 
L

Lars-Åke Aspelin

Excel 2007 - I have a worksheet where column B is filled with random scores.
In column C I would like to have the corresponding score in column B ranked
against all the other scores in column B so it would rank each of the scores
between 1-10.

Example:
Column B Column C
9.56 2
10.12 1
8.11 4
8.99 3
etc.

If the value in column B changes (it sometimes does) then all the ranks in
column C should adjust accordingly. Is this possible?

Thanks!

If your data starts on row 1, try this in cell C1

=RANK(B1,B$1:B$100)

change the 100 to fit the size of your data in column B.

copy down as far as there is data in column B.

Hope this helps / Lars-Åke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top