cheers for the response Hans, I tried this first but it doesn't work.
Excel populates the following formulas down column B when dragging the
fill handle:
=A1
=A1
=A2
=A2
=A5 << it skips 3 here
=A5
=A6
=A6
=A9 << skips another 3
=A9
=A10
=A10 etc.....(continues to do this)

Any other sugesstions?


--
jhct
------------------------------------------------------------------------
jhct's Profile: http://www.excelforum.com/member.php...o&userid=31562
View this thread: http://www.excelforum.com/showthread...hreadid=512566