Problem with autofill series in Excel

[Idefix]

Hi,

I am trying to make one column(A1). Row 1 to 15 should contain ones, row 16 to 30 two's etc..

Below the examples of my errors (I tried with three numbers but I actually need 15). When I first drag the bottom right corner I get 2,4 instead of 3. When I change the properties of the cells to numbers it looks good, but when you look closely you see that Excel first adds a 2 so instead of 3 two's it becomes four. Hopefully its more clear now what I want to achieve.

First column contains my first attempt and with the second one I changed the cell properties!
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]2,4[/TD]
[/TR]
[TR]
[TD="align: right"]2,657143[/TD]
[/TR]
[TR]
[TD="align: right"]2,914286[/TD]
[/TR]
[TR]
[TD="align: right"]3,171429[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advance!

 

[FormR]

Welcome to the forum;

Try this putting formula in cell A1 and dragging down:

=ROUNDUP(ROWS($A$1:A1)/15,0)

 

[Idefix]

Welcome to the forum;

Try this putting formula in cell A1 and dragging down:

=ROUNDUP(ROWS($A$1:A1)/15,0)

Thank you for your help! Unfortunatelly did not work! I did have a closer look and saw that the properties have no influence, it did look that way because it was rounding. When you drag 1,2,3 down you get 4,5,6. I'm looking for the same thing only with multiple ones en two's etc! Not that Excel automatically makes it 2,4 and I round it afterwards to 3. Should be possible but I don't know how :S

 

[FormR]

Works for me? You need to copy the formula to cell A1 and then copy it doen as far as is needed.

Excel Workbook
	A
1	1
2	1
3	1
4	1
5	1
6	1
7	1
8	1
9	1
10	1
11	1
12	1
13	1
14	1
15	1
16	2
17	2
18	2
19	2
20	2
21	2
22	2
23	2
24	2
25	2
26	2
27	2
28	2
29	2
30	2
31	3
Sheet1

 

[Idefix]

Works for me? You need to copy the formula to cell A1 and then copy it doen as far as is needed.

Spreadsheet Formulas

Cell Formula A1 =ROUNDUP(ROWS($A$1:A1)/15,0) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thanks for checking again! The formula didn't work (and gave an error) because the formula is not universal (got another language). Changed it to the right language and boom it was working! Thanks a lot! This saves me a lot of time! Have a great weekend!