SOLVED

# Continue series of similar numbers

Occasional Contributor

# Continue series of similar numbers

Hello, I want to continue series of similar numbers. Sow, 1111, 2222, 3333, etc.
How can I do this?

8 Replies

# Re: Continue series of similar numbers

@Bremzki Would the pattern be to always add 1111 to the previous cell? If so, enter 1111 in, for example, cell A1. Then, in A2 enter the formula =A1+1111 drag it down as long as you want.

But just to be sure, what would be the cell following 9999? The above formula will return 11110. I you would want anything else (perhaps 10101010 or 0000) that would be something else.

# Re: Continue series of similar numbers

@Riny_van_Eekelen, thanks for the fast reply. I guess my description wasn't clear enough. What I mean is in A1 1, A2 1, A3 1, A4 1, A5 2, A6 2, A7 2, A8 2, A9 3, etc. So in four underlaying cells the same number and the four underneath +1.

# Re: Continue series of similar numbers

@Bremzki Perhaps like in the picture below?

Correct

# Re: Continue series of similar numbers

Sorry, but I missed your formula. Now I saw it, but it doesn't work... The mention says: you have not provided enough arguments for this function.
best response confirmed by allyreckerman (Microsoft)
Solution

# Re: Continue series of similar numbers

@Bremzki Try the attached file.

# Re: Continue series of similar numbers

Perfect. Thanks very much!