Results 1 to 5 of 5

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

Threaded View

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    Oregon
    MS-Off Ver
    Excel 2007
    Posts
    3

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

    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
    Last edited by makiah; 05-10-2013 at 01:53 AM. Reason: Sorry. Typo in the 2nd paragraph. I put the incorrect line down. It is line 16 not 40

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1