Thread: How do I find the position of the lowest value in a row?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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?


Reply With QuoteReply With Quote