Forum Discussion

Julydoo's avatar
Julydoo
Copper Contributor
Jun 20, 2021

Increment a row up with increasing number

Hi. Can I increment a row up with increasing number?

 

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Julydoo 

     

    Cells from 1 to 20 can be clicked with = A1 + 1 and the cell at the bottom right and dragged down.

    From 20 to 1 exactly the same, only use instead of plus minus = A1-1

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Resources