Myrna Larson Wrote:
Will that work when the formula is copied down? In the 2nd row, it
becomes an
array: $1:2

[...]


Yes, it will. It's result is not array.


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=273740