Closed Thread
Results 1 to 4 of 4

will autopopulate the group depending on the top 3 results

  1. #1
    Forum Contributor
    Join Date
    02-16-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    228

    will autopopulate the group depending on the top 3 results

    I already have the formula so the column B will appear, but my problem is the column A

    FX

    Product 1 A 456
    Product 1 B 4536
    Product 1 C 45
    Product 1 D 456
    Product 1 E 45
    Product 2 A 456
    Product 2 B 4536
    Product 2 C 456
    Product 2 D 786
    Product 2 E 785


    top1 ? B 4536
    top2 ? B 4536
    top3 ? D 786


    question top3.xlsx

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,745

    Re: will autopopulate the group depending on the top 3 results

    Didn't you like my suggestion in your other thread?

    http://www.excelforum.com/excel-form...3-results.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,490

    Re: will autopopulate the group depending on the top 3 results

    Put this in E12:

    =MATCH(LARGE(INDEX($D$1:$D$10+(ROWS($D$1:$D$10)-ROW($D$1:$D$10))/10^5,0),ROWS($1:1)),INDEX($D$1:$D$10+(ROWS($D$1:$D$10)-ROW($D$1:$D$10))/10^5,0),0)

    then in B12 you can have this:

    =INDEX(B$1:B$10,$E12)

    which can be copied into C12 and D12.

    Then copy B12:E12 down.

    Hope this helps.

    Pete

  4. #4
    @dministrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010
    Posts
    33,062

    Re: will autopopulate the group depending on the top 3 results

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    _________________
    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!)

Closed 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