Thread: How to find the address of the min cell within a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default How to find the address of the min cell within a range
one way:

=CELL("address",INDEX(A1:A10,MATCH(MIN(A1:A10),A1: A10,FALSE)))


In article ,
Will wrote:

Ihave a range A1:A10 and I need to know the Cell address that contains the
min value... any ideas?
Reply With QuoteReply With Quote