# will autopopulate the group depending on the top 3 results

1. ## 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. ## Re: will autopopulate the group depending on the top 3 results

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

3. ## 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. ## 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.

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

#### 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