Forum Discussion
SEQUENCE FUNCTION Excel
Is there formula available that can generate a sequence, specifically a formula that can produce a sequence that the Start begins with a letter.
EXAMPLE:
=SEQUENCE(150,1,W012345,1)
The sequence function formula I have used returns a sequence of numbers but cannot accommodate a Start that begins with a letter.
EXAMPLE:
=SEQUENCE(150,1,W012345,1)
The sequence function formula I have used returns a sequence of numbers but cannot accommodate a Start that begins with a letter.
1 Reply
W012345 is a cell reference, most likely blank.
If you want a sequence if IDs starting with a W then try something like
= "W" & SEQUENCE(100,1,50)
