Thread: Reference to a cell returned by MIN...how?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Reference to a cell returned by MIN...how?
Hi,

You could try:-

=ADDRESS(MATCH(MIN(A1:A100),A1:A100,0),1)

Where the range you are looking for the minimum in is A1 -A100

Mike

"Mac" wrote:

How do I get to the row and col reference of a cell whose value I obtain via
calling MIN (I need to input this referece to OFFSET...)
Reply With QuoteReply With Quote