use C$1:F$1

--
Kind regards,

Niek Otten

"DKY" wrote in message ...

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