| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill in Column with a series of repeating numbers
I am trying to fill in an amortization years column. The first 12 rows are
"1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've got 360 rows to fill. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill in Column with a series of repeating numbers
A1: 1 A2: =IF(MOD(ROW(),12)=1,A1+1,A1) Fill down -- Jim Cone Portland, Oregon USA ( Review of Special Sort add-in: http://www.contextures.com/excel-sort-addin.html ) "mimi" wrote in message I am trying to fill in an amortization years column. The first 12 rows are "1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've got 360 rows to fill. Any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill in Column with a series of repeating numbers
=int((row()+11)/12)
-- David Biddulph "mimi" wrote in message ... I am trying to fill in an amortization years column. The first 12 rows are "1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've got 360 rows to fill. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill in a series of numbers | Excel Discussion (Misc queries) | |||
| Fill repeating Numbers | Excel Discussion (Misc queries) | |||
| How Do I change repeating numbers in a column | Excel Discussion (Misc queries) | |||
| Fill In a Series Letters and Numbers | Excel Discussion (Misc queries) | |||
| Repeating a sequence of numbers down a column | Excel Discussion (Misc queries) | |||
Hybrid Mode
