Forum Discussion
UKdeejay
Sep 16, 2024Copper Contributor
'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 a way to get Excel to autofill a sequential number when new data is entered in a Row?
For example, Column A is sequential numbers starting with '1' (without the ' ' inverted commas) in A1, then 2 in A2 etc and every time data is entered in a new Row in Column B (for example), a new sequential number is entered automatically in the same Row in Column A? TIA
- UKdeejayCopper ContributorThanks SergeiBaklan - that worked well.
For some reason the 'Like' button isn't working...?