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

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