Try this

=MATCH(MAX(20:20),20:20,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Frank Drost" wrote in message
...
I have to check each row for the maximum value in that row. But instead of
writing the maximum value of that row, I have to write the column number
of
that maximum value. The very first row of my dataset goes from 1 to 100,
indicating 100 columns, and is there only to number the columns. So, the
column number has to be picked from that row.
For instance, in row 20, the maximum value is 10, and it is at column 56.
How can I as output of a formula (or conditional formatting) get as answer
56?

ta