Forum Discussion
Solved
Function that takes the max value and shows the name of the column
Hello everybody, I've got a problem with developing a function that will, choose the bigest value from the rows fields and as the outcome will show the name of the column in F column. Maybe any of yo...
When something like
=INDEX($B$1:$E$1,1,MATCH(MAX(B2:E2),B2:E2,0))
in F2 (for the second row), copy down then. It returns #N/A if no one number in the row, you may use IFERROR to correct
Exactly, thats what I need :)
When something like
=INDEX($B$1:$E$1,1,MATCH(MAX(B2:E2),B2:E2,0))
in F2 (for the second row), copy down then. It returns #N/A if no one number in the row, you may use IFERROR to correct
- obviously it worked, thanks Sergei :)