+ Reply to Thread
Results 1 to 6 of 6

Retrieve Data From Cell Based in Array Based on LARGE Function

  1. #1
    Registered User
    Join Date
    10-12-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Retrieve Data From Cell Based in Array Based on LARGE Function

    The jist of what I'm trying to do is rank a set of items automatically based on a score they're given.
    It's for a personal evaluation of students, so in field C6 it will add their name, and in D6 the score. D6 contains the previous formula.
    I've set it up to rank the scores already with the formula: =LARGE($G$13:$L$13,B6), B6 and down being the number in the list. It works very well.
    I'm having issues with retrieving the name from the field in which the scores are tied to.
    An example would be "Doe, John" is cell J5, while his score is at J13.

    Is there a simple way to accomplish what I want, or will I have to do a really convoluted non-dynamic set of IFs or something?

    Thanks for the help!
    Last edited by justarandomguy; 10-13-2014 at 12:59 AM.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Retrieve Data From Cell Based in Array Based on LARGE Function

    Can you upload a sample workbook?

  3. #3
    Registered User
    Join Date
    10-12-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Retrieve Data From Cell Based in Array Based on LARGE Function

    Here you are!
    Attached Files Attached Files

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Retrieve Data From Cell Based in Array Based on LARGE Function

    Does this do what you want?

  5. #5
    Registered User
    Join Date
    10-12-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Retrieve Data From Cell Based in Array Based on LARGE Function

    Yes! :D Thank you so much.

    One last little question. Do you have any tips for changing the title so anyone else looking for this can find it more easily?

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Retrieve Data From Cell Based in Array Based on LARGE Function

    Quote Originally Posted by justarandomguy View Post
    Yes! :D Thank you so much.

    One last little question. Do you have any tips for changing the title so anyone else looking for this can find it more easily?
    No I can't. Your title very accurately describes what you have and what you want to do with it.

+ 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. [SOLVED] Retrieve data from a cell based on date criteria in another
    By ajob in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-23-2014, 08:49 AM
  2. Data retrieve based on date
    By mahershams in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-18-2013, 10:29 AM
  3. [SOLVED] Solving Large function for dynamic data based on changing periods
    By Darren_Rix in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-16-2013, 04:59 AM
  4. [SOLVED] Retrieve value based on the value of another cell (Lookup)
    By ACDC in forum Excel General
    Replies: 12
    Last Post: 03-27-2012, 05:45 PM
  5. Data retrieve from different file based on date
    By littyjose in forum Excel General
    Replies: 1
    Last Post: 03-21-2007, 12:14 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