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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I find the position of the lowest value in a row? (https://www.excelbanter.com/excel-discussion-misc-queries/88651-how-do-i-find-position-lowest-value-row.html)

melh31

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

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

Bob Phillips

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

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"melh31" wrote in message
...
How do I find the position of the lowest value in a row in Excel?

Peo Sjoblom

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

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?

All times are GMT +1. The time now is 05:56 AM.