thank you for the information its been a great help, my next issue is I want the sequencing numbers to be locked, new entry seq lock, and few columns down another set of seq numbers locked as well. this means if a decision to add a new entry in the middle of the table it still takes the +1 of the last entry
This is great. However I have another dilemma where I have titles inbetween the rows that I need to count. How do I have a continuous counting, even when I delete the number from a cell to avoid counting titles?
Hi - I have a spreadsheet with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
Is there a way to use the formula but in a descending format as I need to insert a blank row above the last completed row and will automatically add the row number in the first column but it should show as “2” if the first completed row is assumed as row “1”?
Hi please help me.. how about automatically add numbering when row added in google spreedsheet? I really need to know because the row will keep added with responses in google form. Thank you in advance for everbody help
THIS IS TOP TIER.
this can be useful for serial numbers or emp ids. thank you sooo much!
thank you for the information its been a great help, my next issue is I want the sequencing numbers to be locked, new entry seq lock, and few columns down another set of seq numbers locked as well. this means if a decision to add a new entry in the middle of the table it still takes the +1 of the last entry
Thanks a lot, this method even works for 10 degit letter and numbers serial in prefix
This is great. However I have another dilemma where I have titles inbetween the rows that I need to count. How do I have a continuous counting, even when I delete the number from a cell to avoid counting titles?
=AGGREGATE(2, 7, A$1:A1) + 1 works better even if you delete rows or if you have filtered the table
Thank you for this great video. It helped a lot.
Thanks for the tutorial.
Good tutorial Chester. Thank you for your work!
Thank you Iván. Your comments are much appreciated.
Hi - I have a spreadsheet with 13 sheets. Each sheet has a table which tracks weekly data. Each week I manually add a new row to the top of the table for the newest weeks data and update the formatting and formula in the new row, for each sheet. I then manually update formulas about the table which tracks MIN, MAX, SUM and AVG. Is it possible to automate these steps for all 13 sheets?
can i use the ROW function if I insert it in the Right side of my table?
Thank's, you helped me :)
Looking for a way to pre-populate a row number prior to adding data in a new row. Thoughts?
Very good informative video sir, keep rocking...
Thank you brother
Thanks..! Nice Tips
Is there a way to use the formula but in a descending format as I need to insert a blank row above the last completed row and will automatically add the row number in the first column but it should show as “2” if the first completed row is assumed as row “1”?
Can a table auto genterate the next number in a series without a formula?
great work
Hi please help me.. how about automatically add numbering when row added in google spreedsheet? I really need to know because the row will keep added with responses in google form. Thank you in advance for everbody help
I'm trying to find a way to number with example: 1, 2 ,2.1, 2.2, 3, 3,1, 4
Super broo
how to start from specific number ? ex: start from number 179 ..
Nicely
i don't even have the sequence function on mine..