Say you want your sequence for 100 cells.

You could try putting =a1 in both cells B1 and C1, etc, through row 50,
then drag the range C1:C50 down to B51. Fill col C the consecutive
sequence 1,2,3,etc for the range c1:c50, and again for C51:C100. Then
sort B1:C100 on col C. this shoudl give you what you're after.

---Glenn


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