# series fill with same number twice

I need to series filll a column with the same number twice. For example A6 = 1,A7 =1, A8=2.,A9 = 2, etc. (ms xls 2007)
###### Who is Participating?

ConsultantCommented:
A1 = 1
A2 = 1
A3 = if(A2=A1,A2+1,A2)

Copy A3 down.

Alan.
0

ConsultantCommented:
If you want them as values, and not formulae, do the above, then copy and paste to values.

Alan.
0

Microsoft MVP ExcelCommented:
Hello,

for example to do this with 200 cells, fill the series to the first 100 cells, going 1,2,3, etc. then fill the next 100, starting again with 1,2,3. Select all 200 cells and sort ascending.

cheers, teylyn
0

EngineerCommented:
You can change Alan3285's formula

=if(A2=A1,A2+1,A2)

to

=A1+1

If you don't have to use the value of the numbers you can fill series starting from 0.5 and increment by 0.5 and display with zero decimal places.

Another formula which can be used and then converted to values is

if starting in row 6 then
=INT((ROW()-4)/2)

if starting in row 7 then
=INT((ROW()-5)/2)

0

Author Commented:
Great resolutions - All!! Alan3285 was first
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.