+ Reply to Thread
Results 1 to 6 of 6

Using LARGE but need to link number to a name

  1. #1
    Forum Contributor
    Join Date
    05-03-2010
    Location
    scotland,uk
    MS-Off Ver
    Excel 2007
    Posts
    186

    Using LARGE but need to link number to a name

    As you can see from this formula I have listed the top 3 numbers out of AU4:AU20 I have used the formula 3 times in three separate cells changing the last digit from 1 to 2 to 3
    =LARGE($au$4:$au$20,1)

    Now in columns AF4:AF20 I have the corresponding names for those figures, how can I tie them up so that I can get it to read like...
    Mary 1 John 2 Graham 3

    Hope this makes sense. Thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    12,974

    Re: Using LARGE but need to link number to a name

    Deleted by bvj
    Last edited by protonLeah; 04-26-2015 at 06:35 PM.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    05-03-2010
    Location
    scotland,uk
    MS-Off Ver
    Excel 2007
    Posts
    186

    Re: Using LARGE but need to link number to a name

    No that doesnt work, it finds names but not the correct ones. I have attached a screen capture which me help explain.
    The correct names should be Moira, Caterina and Alison.
    Column AF to link with AU.

    ranking.JPG

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Using LARGE but need to link number to a name

    Like this...

    =INDEX(AF4:AF20,MATCH(LARGE(AU4:AU20,1),AU4:AU20,0))

    Replace the 1 with whatever instance of large you want.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Forum Contributor
    Join Date
    05-03-2010
    Location
    scotland,uk
    MS-Off Ver
    Excel 2007
    Posts
    186

    Re: Using LARGE but need to link number to a name

    Tony Valko, yes that works.

    Thank you

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Using LARGE but need to link number to a name

    You're welcome. Thanks for the feedback!

+ 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. Problematic link in large workbook
    By Len33 in forum Excel General
    Replies: 0
    Last Post: 03-12-2012, 10:05 AM
  2. Large Form Help: Handling large number of text boxes and labels
    By laterdaysluke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2010, 03:12 PM
  3. Best way to set a large number of variables?
    By starcrwzr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2009, 06:58 PM
  4. Entering Large Number
    By TJS in forum Excel General
    Replies: 8
    Last Post: 12-17-2005, 12:25 PM
  5. dissect large number
    By Dummy in forum Excel General
    Replies: 4
    Last Post: 03-21-2005, 10:06 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