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

B

Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove lowest 2 values in a row? 2
How to bold lowest value 2
Find the lowest number? 3
How to highlight the lowest valued cell in a column in Excel 2003 2
difference between the lowest and next lowest value 4
lowest number in a row that is greater than zero 4
summing a row, remove lowest values from the total 2
Highlight lowest price in a row. 6

Top