"quincythequill"
<quincythequill.2cxri1_1156240806.2141@excelforu m-nospam.com skrev i en
meddelelse
news:quincythequill.2cxri1_1156240806.2141@excelfo rum-nospam.com...

Can Autofill handle the following sequence? or can anyone suggest a way
to create this sequence in a single column?

1
1251
2501
3751
2
1252
2502
3752

until 1 reaches 1250 and 1251 reaches 2500 and 2501 reaches 3750 and
3751 reaches 5000




quincythequill

One way:

In e.g. A5 insert this formula:

=1250*(MOD(ROW()-ROW($A$5),4))+INT((ROW()-ROW($A$5))/4+1)

Copy A5 down as long as necessary.

If you start in cell A3, please replace $A$5 by $A$3


--
Best regards
Leo Heuser

Followup to newsgroup only please.