One way would be
=MATCH(MAX(A1:D1),A1:D1)-1+COLUMN(A1)
--
David Biddulph

"Aline" wrote in message
...
i have tried to use the column function to get the column number for the
max
value of a range of numbers but it didn't work. i know that a solution for
this exist but i have tried different ways and in vain. any ideas?!