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?
AlanConnect With a Mentor ConsultantCommented:
A1 = 1
A2 = 1
A3 = if(A2=A1,A2+1,A2)

Copy A3 down.

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

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

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
Saqib Husain, SyedEngineerCommented:
You can change Alan3285's formula




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

if starting in row 7 then

howcheatAuthor Commented:
Great resolutions - All!! Alan3285 was first
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.

All Courses

From novice to tech pro — start learning today.