+ Reply to Thread
Results 1 to 4 of 4

Auto-Insert Adjacent Cell Contents to Cell Chosen by LARGE Formula

  1. #1
    Registered User
    Join Date
    04-23-2009
    Location
    Washington, D.C.
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Auto-Insert Adjacent Cell Contents to Cell Chosen by LARGE Formula

    Hi all -

    I have two columns of data. Column A (A1:A10) contains only text. Column B (B1:B10) is entirely numerical. Beneath my 10 rows of numerical data (B1:B10), I have 5 LARGE functions to pick out the five largest values in the second column's range and display them, after a space of a few rows, under the data in that column (in B13:B17).

    In the cells next to this, A13:A17, I need whatever text in the A column was next to the 5 numerical values that were pulled by the LARGE functions to appear automatically.

    So - if the LARGE formula determined that the largest number in the Column B range was 23, and 23 appeared in B9, then the number 23 will appear in, say, B13. In A13, I need whatever text was in A9 to appear, since that corresponds to B9, which was chosen by the LARGE formula.

    I haven't been able to write a formula to do this.

    Any help is HUGELY appreciated!

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Auto-Insert Adjacent Cell Contents to Cell Chosen by LARGE Formula

    This is an INDEX/MATCH function. In A13 try this:

    =INDEX($A$1:$A$10,MATCH(B13,$B$1:$B$10,0))

    Deeper Explanation:
    http://www.excelforum.com/excel-gene...ame-row.html#3

    Sample file:
    http://www.excelforum.com/attachment...tch-sample.xls
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    04-23-2009
    Location
    Washington, D.C.
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Auto-Insert Adjacent Cell Contents to Cell Chosen by LARGE Formula

    Perfect. Thank you!!

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Auto-Insert Adjacent Cell Contents to Cell Chosen by LARGE Formula

    If that takes care of your need, remember to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

+ Reply to Thread

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