| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat row numbers
Excel 2003
I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27, etc to the end. I'd rather not copy and paste! TIA Carole O |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat row numbers
Put 1 in a1, and this formula in A2, and copy down:
=if(a1=27,1,a1+1) Regards, Fred "Carole O" wrote in message ... Excel 2003 I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27, etc to the end. I'd rather not copy and paste! TIA Carole O |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat row numbers
In A1 type: =MOD(ROW()-1,27)+1 and copy down.
This will enable deletion of row(s) without producing an Error. Micky "Carole O" wrote: Excel 2003 I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27, etc to the end. I'd rather not copy and paste! TIA Carole O |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat row numbers
Micky - I copied and pasted the formula, but when I copy down, all I get is
1's all the way down. I like your idea of being able to delete rows without producing an error. Is there a fix? Carole O "מיכאל (מיקי) אבידן" wrote: In A1 type: =MOD(ROW()-1,27)+1 and copy down. This will enable deletion of row(s) without producing an Error. Micky "Carole O" wrote: Excel 2003 I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27, etc to the end. I'd rather not copy and paste! TIA Carole O |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeat row numbers
Sorry, Micky - my goof! I had manual formula set.
Thanks for your help! Carole O "מיכאל (מיקי) אבידן" wrote: In A1 type: =MOD(ROW()-1,27)+1 and copy down. This will enable deletion of row(s) without producing an Error. Micky "Carole O" wrote: Excel 2003 I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27, etc to the end. I'd rather not copy and paste! TIA Carole O |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| do not repeat numbers in a column | Excel Discussion (Misc queries) | |||
| How to repeat numbers in different cells? | Excel Discussion (Misc queries) | |||
| Do not allow repeat numbers | Excel Discussion (Misc queries) | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| IN EXCEL, HOW CAN I TYPE IN NUMBERS AND HAVE THEM NOT REPEAT? | Charts and Charting in Excel | |||
Hybrid Mode
