Forum Discussion
Error when sequencing auto number
Hello...
Kindly need someone advise on my problem:
So i have created some of data that will be updated in daily basis..
I want to put auto fill number so everytime someone added new row the number will automatically populate..
After some googling there is formula for it so i use it
=Sequence(counta(column)-1)
It is works before i input the table in my dataset..
When i applied the table (insert > table) the formula become "spill" which im not sure why..
Could someone advise?
Thanks
5 Replies
I thought there was a much simpler way to generate a column of sequential numbers. In its simplest form, I start with 1,2. in a1 and a2; then put cursor at the bottom right cell 2, the cursor changes to a cross and then just drag the cell as long as I need, e.g., down ten cells creating 3,4,5,6,7,8,9,10,11,12. All I get now is a column of 1's. I had to create formula in a2, a1+1. then copy down to a12, then copy and paste the entire column as value in order to get a column of reference rows. Pretty absurd.
inidurudi Indeed, the SEQUENCE function generates a dynamic array and these are not allowed inside structured tables. Perhaps the example in the attached file does what you need inside a structured table.
Add data in any of the columns (except the one called Number) and the number in the first column will increment automatically.
Thanks for the reply..
"the SEQUENCE function generates a dynamic array and these are not allowed inside structured tables."
Aahh i got it so i would go for manual one then..
For your suggestions I have tried it but in my case the number become 300, not 1 and when i dragged it is the same number
i tried to add another row it populate random number not in the sequence number
