How to return different column header from 2 same values?

I have a problem..

A1 A2 A3 A4 A5 A6
600 500 400 500 700 300

I'm using =INDEX(A1:F1,MATCH(LARGE(A2:F2,1),A2:F2,0)) to get the column header and =LARGE(A2:F2,COUNTIF(A2:F2,MAX(A2:F2))) to get the value, however, Im getting 2 same header (A2) for value 500 which show in the pic, how should I get A4 as the 4th as shown below? Help needed..thx much

Test.JPG

Perhaps something like this? Using array formula


see u

thx Azumi, however the answer is getting 2 A2 as 3rd and 4th as well.. how should I supposed to get A2 & A4 as 3rd and 4th? thanks again

Oooops sorry im misread your requirement, pls see this

hi azumi, i copy exactly your code to paste in excel, but it returned different answer..see below..
need your help again..thanks

ye.JPG

Sorry forget to tell you, you need to ENTER the formula with this style, press/hit CTRL+SHIFT+ENTER button together, dont' ENTER alone, after that you can copied cross, thats array formula style.

Thanks azumi! Finally i got the style!! Thank you so much for your excellent help!!!