I have been trying to get this formula for excell to work in calc. It should return the column header for the highest value in a row.
=INDEX($B$1:$F$1,0,MATCH(MAX($B2:$F2),$B2:$F2,0))
Is there a better approach?
I have been trying to get this formula for excell to work in calc. It should return the column header for the highest value in a row.
=INDEX($B$1:$F$1,0,MATCH(MAX($B2:$F2),$B2:$F2,0))
Is there a better approach?
and today it seems to be working. I think it was a typo.