Look things up
Number rows automatically
=SEQUENCE(3)How it works in Excel
- 3 is how many numbers to make, starting from 1.
- =SEQUENCE(5,1,10,2) makes 5 numbers from 10, going up by 2.
- Older versions can use =ROW()-1 and copy it down.
The idea in general
It counts for you, so you never type a list of numbers again.
What I assumed
- You want the numbers 1 to 3 going down.
Check the result on your own data before relying on it.