Creating Number Sequence in Groups of 10

[DBWalsh12]

I need to create a grouped sequence that changes every 10 rows.
So in Column A cell A2 the number would start at 01349 and every 10 cells it would decrease by 1 and go on down to 0
so it would look something like this:
01349
01349
01349
01349
01349
01349
01349
01349
01349
01349
01348
01348 ...

Help Please

[TMS]

One way:

=1349-ROUNDDOWN((ROW()-1)/10,0) and copy down


Regards, TMS

[Ace_XL]

If A1 has your first value, in A2 use

Please Login or Register  to view this content.

Copy down
Format cells as "0"#

[oeldere]

Try this one

Please Login or Register  to view this content.

and drag down.

[DBWalsh12]

One way:

=1349-ROUNDDOWN((ROW()-1)/10,0) and copy down


Regards, TMS

Well this works except that it is giving me groups of 9 instead of 10.

[DBWalsh12]

If A1 has your first value, in A2 use

Please Login or Register  to view this content.

Copy down
Format cells as "0"#

Thank you. This one worked the best!

[TMS]

Thought I'd changed it. Should be:

=1349-ROUNDDOWN((ROW(A1)-1)/10,0)

The other version does work provided you start in Row 1 ... and, after the first batch of "1349" it will make groups of 10.

[TMS]

=1349-INT((ROW(A1)-1)/10) would work too.

[martindwilson]

1349 in a1:a10
a11=a1-1
fill down job done