How do I find the position of the lowest value in a row?

[melh31]

How do I find the position of the lowest value in a row in Excel?

[Bob Phillips]

=LOOKUP(2,1/(A1:A10<>""),A1:A10)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"melh31" <[email protected]> wrote in message
news:[email protected]...
> How do I find the position of the lowest value in a row in Excel?

[Peo Sjoblom]

This will give you the address of the cell in row number 2

=CELL("address",INDEX(2:2,MATCH(MIN(2:2),2:2,0)))

Regards,

Peo Sjoblom

"melh31" wrote:

> How do I find the position of the lowest value in a row in Excel?