Unable to sort testing process final scores. decending from high score down.

**makiah** · 05-10-2013, 01:33 AM

I do not have very much experience using Excel but have through trial and error made this scoring sheet for a promotional process. All my formulas work how I want them to however after I am done entering the data I can not figure out how to create a ranked list.

The names in the columns from line 16 down are the evaluators final scores for each candidate listed as a Alpha in Column 1. The scores are each averaged and combined to give a raw score then the final scores show up in the weighted section Lines 3 - 11 and columns 2-4. The final scores are listed rows 3-11 column 6.

Is there a way to have excell automaticaly rank rows 3-11 so that the highest scoring candidates and their associated scores are listed from highest to lowest?2013 DFM. test scores reviewed.xlsx

**FDibbins** · 05-10-2013, 01:44 AM

Hi and welcome to the forum

Im not sure where you want this, but this will rank F3:F11 for you
=RANK(F3,$F$3:$F$11)

**makiah** · 05-10-2013, 02:02 AM

Thank you FDibbins. What I am looking for is to have the line that has each candidates final scoring at the top of the page to be listed numericaly by the total score. The only number that maters as far as ranking would be the 6th colunm (column F ?). The other data may not be numerical but the sum in F would need the coresponding data to follow it to the row it moves to for ranking.

**FDibbins** · 05-10-2013, 02:05 AM

can you show me a sample of what you want?

**makiah** · 05-10-2013, 02:19 AM

I manualy entered it into a new worksheet and completed the first few lines. This is how I am hoping to have the finished product look.
CANDIDATE Presentation- 33% Panel - 33% Inspection - .34% Vet Points + .05 Total
E 0.31144 0.31185 0.32725 0 95.1%
B 0.27294 0.28842 0.33008 0 89.1%
H 0.29631 0.22209 0.31733 0 83.6%
G 0.22619 0.27951 0.27625 0.05 83.2%
C 0.30594 0.26796 0.25358 0 82.7%

Unable to sort testing process final scores. decending from high score down.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Unable to sort testing process final scores. decending from high score down.

Re: Unable to sort testing process final scores. decending from high score down.

Re: Unable to sort testing process final scores. decending from high score down.

Re: Unable to sort testing process final scores. decending from high score down.

Re: Unable to sort testing process final scores. decending from high score down.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions