Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Cells with same number in three rows then skip to next number
I need to fill cells using the same number three times and then the next
number three times and so on: Each time I drag to fill it adds a row and the numbers change to 178.999303. 178 178 178 179 179 179 -- Tracy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Cells with same number in three rows then skip to next number
A1: 178
A2: 178 A3: 178 A4: =A1+1 Copy down as needed. Then, if you want these numbers to be actual numbers, and not formulas anymore, select your column of data, copy it, then paste special: values over the top of itself. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Tracy" wrote: I need to fill cells using the same number three times and then the next number three times and so on: Each time I drag to fill it adds a row and the numbers change to 178.999303. 178 178 178 179 179 179 -- Tracy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Cells with same number in three rows then skip to next number
In A1: 178
In A2: =A1+(MOD(ROW()-1,3)=0) copy down as far as needed "Tracy" wrote: I need to fill cells using the same number three times and then the next number three times and so on: Each time I drag to fill it adds a row and the numbers change to 178.999303. 178 178 178 179 179 179 -- Tracy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Down reference of even number rows | Excel Worksheet Functions | |||
Macros fill cells regardless of row number | Excel Discussion (Misc queries) | |||
formula in excel to skip cells having - number and add only + | Excel Worksheet Functions | |||
formula(excel) to skip cells having - number and add + one | Excel Worksheet Functions | |||
formula will not fill correctly due to odd number rows | Excel Worksheet Functions |