| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is my drag and fill not following the pattern?
I'm trying trying to create a column of number in a pattern:
1,1,1,2,2,2,3,3,3 etc. When I use the drag and fill option to continue this pattern, it inserts extra rows and included decimals. How do I prevent this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is my drag and fill not following the pattern?
=INT((ROWS($1:1)-1)/3)+1
copy down as far as needed "NAKA" wrote: I'm trying trying to create a column of number in a pattern: 1,1,1,2,2,2,3,3,3 etc. When I use the drag and fill option to continue this pattern, it inserts extra rows and included decimals. How do I prevent this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is my drag and fill not following the pattern?
Dear Teethless Mama -- You are a lifesaver. Thanks so much!!
"Teethless mama" wrote: =INT((ROWS($1:1)-1)/3)+1 copy down as far as needed "NAKA" wrote: I'm trying trying to create a column of number in a pattern: 1,1,1,2,2,2,3,3,3 etc. When I use the drag and fill option to continue this pattern, it inserts extra rows and included decimals. How do I prevent this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is my drag and fill not following the pattern?
You're Welcome!
"NAKA" wrote: Dear Teethless Mama -- You are a lifesaver. Thanks so much!! "Teethless mama" wrote: =INT((ROWS($1:1)-1)/3)+1 copy down as far as needed "NAKA" wrote: I'm trying trying to create a column of number in a pattern: 1,1,1,2,2,2,3,3,3 etc. When I use the drag and fill option to continue this pattern, it inserts extra rows and included decimals. How do I prevent this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is my drag and fill not following the pattern?
Hi,
Here is one solution: =INT(ROW(3:3)/3) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "NAKA" wrote: I'm trying trying to create a column of number in a pattern: 1,1,1,2,2,2,3,3,3 etc. When I use the drag and fill option to continue this pattern, it inserts extra rows and included decimals. How do I prevent this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pattern Fill | Charts and Charting in Excel | |||
| Graph Fill Pattern Question | Charts and Charting in Excel | |||
| I want to use a fill series to copy down a pattern of dates. | Excel Discussion (Misc queries) | |||
| inserting a pattern fill in a chart in excel2007 | New Users to Excel | |||
| Auto Fill Links with a Pattern | Excel Discussion (Misc queries) | |||
Linear Mode
