Results 1 to 9 of 9

Ranking scores/names from multiple sheets on summary page

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2008
    Location
    Inland Empire, CA
    Posts
    5

    Ranking scores/names from multiple sheets on summary page

    Hey everyone,

    Here is what I am trying to accomplish for a class of mine...
    Each student has their own profile sheet. Among other things it will have their name and score. Such that name is in cell A1, and score in B4 or something.

    I would like to have a summary page that will display the top 5 scores and the corresponding names. I used the "=Large" formula to get the top 5 scores. Now I need to reference the name that goes with each score.

    I'd also like the formula to automatically adjust for new sheets (students) being added to the workbook. If I have a constant beginning and end sheet this should be sufficient right?

    Thanks so much...

    Jon
    Last edited by VBA Noob; 11-17-2008 at 03:37 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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