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...
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)