repeat number multiple times

  • Thread starter Thread starter Brenda from Michigan
  • Start date Start date
B

Brenda from Michigan

Excel 2003 SP3

I frequently need to put the week number on a spreadsheet.
Example:
1 seven times for week one on rows 1-7
2 seven times for week two on rows 8-14
3 seven times for week three on rows 15-21, etc.
Is there a quicker way to do this than just type in the number seven times?
Thanks!
 
Put this formula in your first cell and then copy it down as far as
necessary...

=INT((ROW(A1)-1)/7)+1
 
Brenda

If the week number is in A2, in A3 type = A$2 and copy down

In B2 type =A2+1 and copy across as far as you need. then select the
formulas in A3:A7 and copy these formulas as far as needed. Then just change
A2 once a month.

If there are columns between these to enter data these can be inserted later.

HTH

Peter from Liverpool
 
Excel 2003 SP3
I frequently need to put the week number on a spreadsheet.
Example:
1 seven times for week one on rows 1-7
2 seven times for week two on rows 8-14
3 seven times for week three on rows 15-21, etc.
Is there a quicker way to do this than just type in the number seven
times? Thanks!
Click to expand...

One way is to put this in row 1 and copy down:
=INT((ROW()+6)/7)
 
Thank you very much! This worked beautifully. Now I'll research the formula
to try to understand what it is doing so I can modify it for other uses.
Thanks again!!!!!
 
Back
Top