Posts by IGACICI

    Hi, AlanSidman... I am sorry that I was not clear in my explanation,..


    I'll try to explain, again, what I am asking as a result in column H... here I have calculated in Column G, maximum value from Columns A, C and E... Used formula =LARGE((A2,C2,E2),1)


    in column H, if maximum value is in the cell A2, my result should have Column B Header value and cell B2 value... if max percentage value is from cell C2, then the result should show Column D Header and cell D2 value...


    I have manually filled data in Column H as an example which values i want as result

    Files

    • Book1.xlsx

      (18.9 kB, downloaded 15 times, last: )

    hello,

    I was trying to get in column H concatenated Header data and (next to the right) column data for maximum value of Percentage value in a row which is calculated in column G...


    tried some formula with ''INDEX,MATCH'', but must admit my skills in excel are still at baby level... :)


    for better understanding, I made a screenshot of my table where I've manually filled ''data'' as it should look as a result in column H


    Hope anyone could help

    best regards