Forum Discussion
Solved
'Open-ended' sequential numbering of Rows in Excel...
I have been looking at the SEQUENCE function but, if I understand it correctly, you need to enter an end point for how many sequential numbers you want Excel to autofill (e.g. 1 to 1000)? Is there ...
Thanks SergeiBaklan - that worked well.
For some reason the 'Like' button isn't working...?
For some reason the 'Like' button isn't working...?
- I hope it is OK to ask a follow-up question on this Thread...
If I want to continue the automatic, sequential numbering of Rows on the next Worksheet in the SAME Workbook, is that possible?
For instance, if sequential numbering of Rows on Sheet 1 is let's say, 1 to 100, can I start sequential numbering of Rows on Sheet 2 at 101? TIADoes this do what you want?
=SEQUENCE(COUNTA(B:B), , COUNTA('Sheet 1'!B:B)+1)
where Sheet 1 is the name of the first sheet.
- That worked, thanks. Hopefully I can edit it to work across multiple Worksheets in my Workbook.
