Forum Discussion

Bremzki's avatar
Bremzki
Copper Contributor
May 03, 2021
Solved

Continue series of similar numbers

Hello, I want to continue series of similar numbers. Sow, 1111, 2222, 3333, etc. How can I do this?
excel
Bremzki's avatar
Bremzki
Copper Contributor
May 03, 2021
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's avatar
    Bremzki
    Copper Contributor
    May 03, 2021
    Correct
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      May 03, 2021

      Bremzki Good. Glad I could solve your problem.

      • Bremzki's avatar
        Bremzki
        Copper Contributor
        May 03, 2021
        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.

Resources