Restart numbering ater a set number of rows

  • Thread starter Thread starter Kleaves
  • Start date Start date
K

Kleaves

I have an excel spreadsheet with 4 columns.

the first two columns contains numbers which will never change
the third column starts off with 0 (zero) and is repeated for 255 rows
then on the 256 row it needs to change to 1 (so basically increment by
1 every 255 rows) the fourth column starts at 0 (zero) and counts up
to 255 but then needs to reset it self back to 0 on the 256 row.

Help Please!!!!!:confused:
 
One way:

I'm assuming you want column C to cycle in blocks of 256 - 0 to 255
- like column D does, not 255:

C1: =INT((ROW()-1)/256)
D1: =MOD(ROW()-1,256)


Copy C1:D1 down as far as necessary. If desired, you can then copy
the columns and paste special, selecting the Values radio button, to
remove the formulae.
 
Back
Top