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