Thread: column number of the answer to MIN
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DKY
 
Posts: n/a
Default column number of the answer to MIN

I just noticed, it's because it changes it to this
=(INDEX(C2:F2,1,MATCH(MIN(C3:F3),C3:F3,0)))&" "&MIN(C3:F3)
instead of this
=(INDEX(C1:F1,1,MATCH(MIN(C3:F3),C3:F3,0)))&" "&MIN(C3:F3)

How do I keep that first C1:F1 the same if I'm copying it down?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=524315

Reply With QuoteReply With Quote