Thread: How do I find the position of the lowest value in a row?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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?
Reply With QuoteReply With Quote