close
How do I find the position of the lowest value in a row in Excel?
=LOOKUP(2,1/(A1:A10lt;gt;quot;quot;),A1:A10)
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
quot;melh31quot; gt; wrote in message
...
gt; How do I find the position of the lowest value in a row in Excel?
This will give you the address of the cell in row number 2
=CELL(quot;addressquot;,INDEX(2:2,MATCH(MIN(2:2),2:2,0)))
Regards,
Peo Sjoblom
quot;melh31quot; wrote:
gt; How do I find the position of the lowest value in a row in Excel?
全站熱搜
留言列表
