prochasska
New Member
- Joined
- Jan 16, 2018
- Messages
- 9
Hello,
I have a spreadsheet where I want to enter consecutive numbers every three rows (the number of rows can vary, it can be two, three, four, five, etc.).
See example below.
London 1
Brighton 2
LA 3
Italy 1
Spain 2
Austria 3
Please can you advise on a formula?
BR,
Monika
I have a spreadsheet where I want to enter consecutive numbers every three rows (the number of rows can vary, it can be two, three, four, five, etc.).
See example below.
London 1
Brighton 2
LA 3
Italy 1
Spain 2
Austria 3
Please can you advise on a formula?
BR,
Monika