Home » Forums » Open Source Learning Center » Question and Answer

Ranking in Excel

Submitted by jayman on 16 January, 2014 - 19:10

Hi, I'm trying to rank score on a score sheet but the final scores to determine placing are not in consecutive cells and the ranking formula doesn't seem to want to work. Can anyone help me out here?

Thanks

AttachmentSize
Scoring.xlsx11.92 KB
‹ Overtime Formula Gives Negative Answers creating an outlook calendar date from an excel column ›
»

try this

Submitted by wabre681 on 16 January, 2014 - 19:44.

in the all final score cells(K7,K12,K17...) insert the following formula:
=IFERROR(SUM(J7:J8),"")

in the all Rank cells(A7,A12,A17...) insert the following formula:
=IFERROR(RANK(K27,$K$7:$K$37,0),"")

»

Thanks Wabre, i tried as you

Submitted by jayman on 16 January, 2014 - 19:54.

Thanks Wabre, i tried as you said and the rank field comes up blank.

»

Sorry Wabre, just looked at

Submitted by jayman on 16 January, 2014 - 20:05.

Sorry Wabre, just looked at it again and noticed that the string for the Rank started with K27 instead of K7. Looks to be working now!
Saying that, is there a way to get the ranking to position in order from 1 to 8 or whatever number?

Thanks a million

»

??

Submitted by wabre681 on 16 January, 2014 - 20:18.

You want to see all ranks 1-8

or

you want the total score ranked #1 on top followed by #2,#3

»

Total Score

Submitted by jayman on 16 January, 2014 - 20:22.

I want the Total Score ranked so i want all the scores, name and total to be in order so it looks the same as it does now but in order from 1-8.

Thanks

»

if you are looking to have

Submitted by wabre681 on 16 January, 2014 - 20:32.

if you are looking to have the data for the #1 rank to move up once it has been ranked automaticlly that not something i can help you with.

manually once it is ranked u can move them and place in the order u want to see them.

another solution is to have a seperate table the pulls from this one

name rank score
J. doe 1 43
w. doe 2 40

»

OK Thanks for all your help!

Submitted by jayman on 16 January, 2014 - 20:38.

OK Thanks for all your help!

»