eferrero
New member
- Joined
- Mar 22, 2011
- Messages
- 17
- Reaction score
- 0
- Points
- 0
- Location
- Brisbane
- Website
- www.edferrero.com
Ok, I'll start with a question;
Does anyone have a nice way to generate a sequence of numbers (1,2,3,4..) with a formula?
I need this to be used in a Named Range.
So I don't want to use a helper column and enter =A1+1. Neither do I want to use the =ROW() formula with a cell reference.
The best I've come up with so far is to define a name,
Increment =ROW(OFFSET(INDIRECT("A1"),0,0,1000000,1))
That works, but looks a little clumsy to me. aNYONE HAVE A BETTER WAY OF DOING THIS?
Does anyone have a nice way to generate a sequence of numbers (1,2,3,4..) with a formula?
I need this to be used in a Named Range.
So I don't want to use a helper column and enter =A1+1. Neither do I want to use the =ROW() formula with a cell reference.
The best I've come up with so far is to define a name,
Increment =ROW(OFFSET(INDIRECT("A1"),0,0,1000000,1))
That works, but looks a little clumsy to me. aNYONE HAVE A BETTER WAY OF DOING THIS?