I am searching for a way to obtain column-references in Excel.
I would like to search through a row (B12:G12) and look for the highest number. That could be done with the MAX-formula. But instead of the value, I would like to get the column reference of that cell, like B, C, D, E, F, G.
Is there a way to do that? I already tried the Address-/ and Index-formula, but that didn't work.
Thanks a lot and greetings!
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…