How do I find the position of the lowest value in a row in Excel?
B Bob Phillips May 15, 2006 #2 =LOOKUP(2,1/(A1:A10<>""),A1:A10) -- HTH Bob Phillips (remove xxx from email address if mailing direct)
=LOOKUP(2,1/(A1:A10<>""),A1:A10) -- HTH Bob Phillips (remove xxx from email address if mailing direct)
P Peo Sjoblom May 15, 2006 #3 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
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
