I'm not sure the correct term, so I've called it a progressive number.
I have the following formula:
At the end of this formula is '1'.
I would like to edit this formula so when I filled it across to adjacent cells, the '1' at the end would increase by +1. e.g 2,3,4,5.
What's the best way of doing this?