Continue series of similar numbers

Occasional Contributor

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

8 Replies

@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.

@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.

@Bremzki Perhaps like in the picture below?

Screenshot 2021-05-03 at 17.09.24.png


@Bremzki Good. Glad I could solve your problem.

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)

@Bremzki Try the attached file.

Perfect. Thanks very much!