+ Reply to Thread
Results 1 to 2 of 2

Vlookup - Finding additional values from duplicates using an additional column

  1. #1
    Registered User
    Join Date
    10-03-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    4

    Vlookup - Finding additional values from duplicates using an additional column

    I am using a spreadsheet as a score sheet for a competition. One of the columns is the student's GPA. After entering all the scores there are duplicate final scores. I need a way to have it look at the final score and then use the GPA so that it will not put a duplicate value in the final column.
    al
    Column N is the Total Column, Column O has the Names that correspond to the Total Column. Currently I am taking this total and putting it into Column Q (High Scores) in high to low order. Column R should have the names that match the scores. But with duplicate scores, it is only putting the first name associated with the score. I would like to use the GPA as a final determining factor for the duplicate scores. The higher GPA would come before a lower GPA. I have tried to put an additional column to bring the GPA over to correspond with the High Scores Column, but could not get it to work.

    There are actually more names for the competition and the top 10 will be moved to a different sheet and further judged.

    I have attached a sample with the exact formulas that I am using.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Vlookup - Finding additional values from duplicates using an additional column

    Hello,
    See attached file.
    I've modified columns P, Q and R.
    By adding the GPA / 1000 to the score and using a INDEX/MATCH search, you can remove the duplicates.

    Note : I'm adding the GPA values divided by 1000 to the score to to prevent that someone with a high GPA but low score has a better ranking then someone with a lower GPA but a better score.
    Attached Files Attached Files
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Additional Code to check for duplicates in multiple columns
    By Craigs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2014, 04:19 AM
  2. [SOLVED] VLOOKUP??? With additional condition??
    By wpnsx in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-11-2013, 12:48 PM
  3. [SOLVED] Vlookup with additional criteria
    By coolzero in forum Excel General
    Replies: 14
    Last Post: 09-20-2012, 10:45 AM
  4. Replies: 9
    Last Post: 01-13-2012, 03:14 PM
  5. Excel 2007 : Deleting Duplicates WHILE maintaining additional columns
    By bioinformatics_guy in forum Excel General
    Replies: 0
    Last Post: 03-02-2011, 12:56 PM

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