Thank you Chris, I watched this video with closed captioning on because my wife is watching TV right beside me and I could follow you very well from the captioning.
I went through a couple of videos on using SEQUENCE along with CHOOSE to create a calendar, but I couldn't really understand them. Your explanations are always understadable, so I hope that you can teach me how to do this.
This is helpful, I've had this issue before so this solution is most appreciated. I would have done B2:B in method 5 so that I don't have to worry about the data range ever extending beyond the scope of the formula however. Great video!
Yes. This is new to me. I always did the 3rd method, but I thought there had to be a better way. I have an old version of Excel on my home computer, but my work computer has 365 - so I'll use Sequence the next time at work when the situation arises. Thank you.
Thank you thank you I’m trying to organize my audiobooks in sequence by author,title series, genre , narrator, length etc so I need to number them and this helped. Eventually I’ll want to sort everything but this helps for now. One step at a time. ❤
Thanks for the video. I use the sequence function pretty often for this kind of thing but also use the Row - header Row especially if there is any danger of the dataset being changed to an Excel table - as we all know spilling functions and tables do not play nice together. This also avoids problems if you want to get the data into Power Query in the same workbook and forget to name the range to avoid it being automatically changed to a table.
Thanx for your clear instructions Chris. Just re the seq 'counta' in which you can add to the bottom of the list and the row will be auto. numbered. This worked for me, but when I inserted a row to add data (rather than adding at the bottom of the list), excel simply moved the numbers up leaving the last row without a number - is there a way to remedy this please?
Especially the last one function is awesome, and it is really work if in any excel sheet there is some blank cells is B column because of some semi data of above cells in C column is coming down. Than B column will be left blank and we need to put numbering with regards to B column. Than it will be pretty good. Awesome❤❤❤
What if i Wanted a column that automatically fills the last cell when i add a row, BUT locks the other numbers to the rows. To better explain myself i'd want a spreadsheet with incremental numbers that don't stay put when sorting for date, by assigning the numbers to the product.. sorry english is not my main language
Thank you! I'm so happy I don't have to make my table a formal table. It's too hard to use. It never lets me re-insert a row that's been cut. Do you know how come when I drag it down, it shows spill?
Thank you so much! I needed some function, that counts correct even if I delete a row. So the last method is the best for me. Just one question: is it works with other velues, or only with numbers only? Because in my worksheet in excel I do have another values.
Thank you very much for your effort. But there's a little, yet, inconvenient problem with method 5: when you apply filters, it won't let you change the sequence/order, and an error message pops up alerting you that you can't apply that with ranged array.
Hey Chris, can you use the sequence function and do that same thing for every 5th cell in a column? And if yes, can you also not have it count hidden cells?
Thanks a lot for this very nice way. I have a question: Can I apply this method for a sequence of say two groups: A & B so that IF I added one case in group A or B it will be numbered according to the sequence for that group?
Hi Chris, great tutorial. Question, can I use sequence function for a row where I have repeated numbers and every nth column I need to increase that value with a specific number? Any suggestions please? Thank you.
Great info, Chris. Love the little shortcuts you show just in demonstrating other features. Once in a while there is a benefit of using Page Layout, Sheet and then check, Print Row and Column headings. Mostly it would qualify as an inappropriate way of numbering rows though.
thank you! What if I had the following sequence to enter: img 1 of 200, of 200, of 200, img 3 of 200 , of 200, of 200, img 5 of 200 etc... where the EVEN numbers of images are repeated twice but the odd number only appear once?
Hi Chris, Thank you for the wonderful tutoring! I have a question related to this topic. I want the sequence numbers of the left-hand side five digits in a column like A33575-27800 next A33575-27801 next A33575-27802. Can you explain how to do it, please?
Good afternoon Chris...thank you for showing this...im working on a new project to where my manager is asking me to use 2023-001 as tracker....would you be kind to show me how I would execute? Thank you
I have case numbers I have to enter into a spreadsheet. Example: B11111-2501, B11112-2501, etc. We have monthly new cases, anywhere from 15 to 45. So next month the last four digits will be 2502. Is there a sequence function for that. Thank you
I have one.. is there a shortcut for sequencing two groups of number together.. like 4-20ma in relations to 0-500lbs load cell... So the middle of the scale would be 12ma is equal to 250lbs
these are all great but my issue is, when i want to filter and sort, the numbers always stay the same. does any1 know how can i creat a numbered column, but if for example i want to see that numbered column in descending order, i cant, without changing the numbers. Also its important for me because some of my formulas in the tale refer to that numbered column. so its important for example the data entry i enter in row 14 which is also numbered 14 in the number column, stays that way, even if i sort in descending order ?
ROW function. =ROW() will return the row you working in. For example, if I am on B7 and and in A7 type =ROW() I will get the number 7. To get a 1 I would do =ROW()-6.
Hello, Mark. Unfortunately and for some unknow reason, Dynamic array functions will not work in a Table. You will get a Spill error. The workaround I use is to put the Sequence column outside the table. I'm not sure why dynamic arrays won't work in tables. Hopefully, Microsoft can fix that.
I want to list the number 1 8 times, then a blank cell, then the number 2 8 times and so on. I also want it to stop after listing the number 18 8 times. So let's say I copy the formula to Row 300, I don't want to see numbers greater than 18. Could you help me with a formula/function, please?
I've always known there is a better way than 1, 2, select, drag but never knew what else to do. This is great!
Method 5 is the most reliable .. Thanks and appreciate your direct and simple explanation.
Your instructions are great because you get right to the point and you keep it simple.
Thank you Chris, I watched this video with closed captioning on because my wife is watching TV right beside me and I could follow you very well from the captioning.
Good to know. We use another app most of the time to make sure our captions are correct. Thanks for the positive comment.
Oh jeez, Chris! THANK YOU! I have been doing method 4 for so long and when adding/deleting rows, it was taking too much time to fix! Thank you!!!!!!!
Thank you exactly what i was looking to do! So helpful 😊
You're welcome! Glad I could help.
I went through a couple of videos on using SEQUENCE along with CHOOSE to create a calendar, but I couldn't really understand them. Your explanations are always understadable, so I hope that you can teach me how to do this.
Thanks for showing different ways to add numbers. Thanks
Happy to help
This is helpful, I've had this issue before so this solution is most appreciated.
I would have done B2:B in method 5 so that I don't have to worry about the data range ever extending beyond the scope of the formula however.
Great video!
Love your videos!!! You are my go to Excel guy, thank you so much for sharing your knowledge!!!!!
You're very welcome! I'm happy you're enjoying them.
Was struggling to find out how to do this. Came across your video and figured it out immediately! Thank you
You are welcome!
Perfect! I was looking for just this type of functionality. I'll be using this from now on. Thanks, Chris!
Yes, this is new to me. I used the fill method most often, I will try this one now.
Thanks, Lorenzo.
Thank you, Chris! Very helpful. I knew there was a way to have the sequence automatically update. Enjoyed the video!
I am using the Function No. 5 you showed us! Good to know!
Thank you.
I've always used =Row()-Row(HeaderRow) but I will definitely give Sequence a try. Thanks Chris!
That works also Robert. I didn't even think about that, and I have a video on it. :-) My memory is going.
Yes. This is new to me. I always did the 3rd method, but I thought there had to be a better way. I have an old version of Excel on my home computer, but my work computer has 365 - so I'll use Sequence the next time at work when the situation arises. Thank you.
You should be able to use Excel on the web also for Sequence.
I've always thought there has to be a better way to fill in numbers. Awesome. Thanks
You bet!
Thank you thank you I’m trying to organize my audiobooks in sequence by author,title series, genre , narrator, length etc so I need to number them and this helped. Eventually I’ll want to sort everything but this helps for now. One step at a time. ❤
Thanx for your assist and for being on TH-cam.
Chris. I like your tutorials, they are clear and fun to watch 👍
I appreciate that!
I like the sequence funcation and have already added it into some of my spreadsheets. Thanks!
You're welcome!
Thanks chris for this wonderful way to count for large records
Welcome!
Thanks I needed this. Also you are a great teacher
Thank you!
Thanks for the video. I use the sequence function pretty often for this kind of thing but also use the Row - header Row especially if there is any danger of the dataset being changed to an Excel table - as we all know spilling functions and tables do not play nice together. This also avoids problems if you want to get the data into Power Query in the same workbook and forget to name the range to avoid it being automatically changed to a table.
I have learnt a lot from you today
Thank you!
Nice presentation and good examples. I am going to use the sequence (count function). Thank you.
Thank you very much this saved me so much time on a report!
Glad it helped!
Thanks this is a great function
Glad you like it!
This is great,,, I just used it and it works wonderfully! This channel is great!
Thanx for your clear instructions Chris. Just re the seq 'counta' in which you can add to the bottom of the list and the row will be auto. numbered. This worked for me, but when I inserted a row to add data (rather than adding at the bottom of the list), excel simply moved the numbers up leaving the last row without a number - is there a way to remedy this please?
thank YOU!! really this is what I was looking for
I will use this feature. Thank you again Chris!
Thanks, Irving.
Especially the last one function is awesome, and it is really work if in any excel sheet there is some blank cells is B column because of some semi data of above cells in C column is coming down. Than B column will be left blank and we need to put numbering with regards to B column. Than it will be pretty good. Awesome❤❤❤
Thank you!
i use the method, put 1, click fill, click series, column and put in the number. thank u so much.
I like that method but if you delete a row, the numbers are off.
I love this video. simple an easy to do. Can you tell me how to arrange alphabetical order with data please? would that miss-up the numbers?
Numbers from SEQUENCE will stay the same if you Sort the data. Doesn't matter what field you sort by.
Well., ur method of explaining is very good, and experience speaks❤
This helped me thanks
Glad it worked. TY
Thank you. This is very helpful.
You're welcome!
Thank you so much sir! This was very helpful
You are welcome!
super simple, THANKS
Glad to help.
Nice! Thanks!
Welcome!
I salute you bro. Thanks bro. You are the answered to my prayer! :)
My pleasure
What if i Wanted a column that automatically fills the last cell when i add a row, BUT locks the other numbers to the rows. To better explain myself i'd want a spreadsheet with incremental numbers that don't stay put when sorting for date, by assigning the numbers to the product.. sorry english is not my main language
so much to learn sir. thank you!
Thank you very much Chris.
You are very welcome
Fantastic !!! Thank you
thanks for this one
You're welcome
Thank you! I'm so happy I don't have to make my table a formal table. It's too hard to use. It never lets me re-insert a row that's been cut. Do you know how come when I drag it down, it shows spill?
THE SAME ERROR!
Thank you, I love new ideas
You are so welcome!
Cool brother
Thanks from India❤
Welcome!
Thank you, you made it so easy
Glad to hear that! Thank you.
great info! very useful! thank you❤
Thank you so much! I needed some function, that counts correct even if I delete a row. So the last method is the best for me. Just one question: is it works with other velues, or only with numbers only? Because in my worksheet in excel I do have another values.
Definitely utilizing this.
Thank you very much for your effort. But there's a little, yet, inconvenient problem with method 5: when you apply filters, it won't let you change the sequence/order, and an error message pops up alerting you that you can't apply that with ranged array.
That's our guy. Thank you.
Thank you.
Thank you excellent tutorial
I am definitely going to use that. Thanks.
Thanks, Johnny.
Thank you!!! I got it to work!
Thank you made this task so easy for me a novice user
I definitely use this function. Thanks.
Good deal, will use.
Hey Chris, can you use the sequence function and do that same thing for every 5th cell in a column? And if yes, can you also not have it count hidden cells?
I will be using option #5.Thank you Much.
Great. I have a question when you have the sequence function in excel table is there a specific to write the formula
I also didn’t know about this. Great way to do it.
Thank you.
Just used awesome thank you
No problem 👍
Thanks a lot for this very nice way. I have a question: Can I apply this method for a sequence of say two groups: A & B so that IF I added one case in group A or B it will be numbered according to the sequence for that group?
Hi, quick question how do we use the sequence if we have headings in the list where we do not want it to be included?
Great info
TY!
Thank you for the tip. I need to hide a row and would like the sequence function to ignore the hidden row? Is there a way to do that?
Hi Chris, great tutorial. Question, can I use sequence function for a row where I have repeated numbers and every nth column I need to increase that value with a specific number? Any suggestions please? Thank you.
How do we put the range first and accompanying information later?😊
Super Cool!! TY.
Welcome.
Great info, Chris. Love the little shortcuts you show just in demonstrating other features. Once in a while there is a benefit of using Page Layout, Sheet and then check, Print Row and Column headings. Mostly it would qualify as an inappropriate way of numbering rows though.
thank you! What if I had the following sequence to enter: img 1 of 200, of 200, of 200, img 3 of 200 , of 200, of 200, img 5 of 200 etc... where the EVEN numbers of images are repeated twice but the odd number only appear once?
Hi Chris, Thank you for the wonderful tutoring! I have a question related to this topic. I want the sequence numbers of the left-hand side five digits in a column like A33575-27800 next A33575-27801 next A33575-27802. Can you explain how to do it, please?
thanks, good way to sequence columns!
its really helpful
Thank you!
Cool. What about if I want to create an "endless" record of data, and I need to keep creating the sequential numbers as soon as I add data?
The function I used will do it.
Good afternoon Chris...thank you for showing this...im working on a new project to where my manager is asking me to use 2023-001 as tracker....would you be kind to show me how I would execute? Thank you
good stuff. thank you
You bet. Thanks, Robert.
I have case numbers I have to enter into a spreadsheet. Example: B11111-2501, B11112-2501, etc. We have monthly new cases, anywhere from 15 to 45. So next month the last four digits will be 2502. Is there a sequence function for that. Thank you
GREAT
happy to help
I have specific lists. Can I add a row within a list and renumber automatically?
awesome thanks
You bet!
Thanks!
Welcome!
Thank you 🙏
The last one worked but when I filter out cells, the sequence does not correct itself?
I have one.. is there a shortcut for sequencing two groups of number together.. like 4-20ma in relations to 0-500lbs load cell... So the middle of the scale would be 12ma is equal to 250lbs
these are all great but my issue is, when i want to filter and sort, the numbers always stay the same. does any1 know how can i creat a numbered column, but if for example i want to see that numbered column in descending order, i cant, without changing the numbers. Also its important for me because some of my formulas in the tale refer to that numbered column. so its important for example the data entry i enter in row 14 which is also numbered 14 in the number column, stays that way, even if i sort in descending order
?
I'm using office 2019, do you have any alternative method to get the same job done.
ROW function. =ROW() will return the row you working in. For example, if I am on B7 and and in A7 type =ROW() I will get the number 7. To get a 1 I would do =ROW()-6.
thank you
You're welcome
Hey Chris, there might be an easier option try using "=row()"
Thank you Chris. However it wouldn't work in an official table. What would you use?
Hello, Mark. Unfortunately and for some unknow reason, Dynamic array functions will not work in a Table. You will get a Spill error. The workaround I use is to put the Sequence column outside the table. I'm not sure why dynamic arrays won't work in tables. Hopefully, Microsoft can fix that.
What if you want to sequence filtered rows?
I do not believe that will work with Filters.
I want to list the number 1 8 times, then a blank cell, then the number 2 8 times and so on. I also want it to stop after listing the number 18 8 times. So let's say I copy the formula to Row 300, I don't want to see numbers greater than 18. Could you help me with a formula/function, please?
thanks but it doesnt work in excel tables. is there another solution please?
I add a column outside the table. Hopefully Microsoft will fix this soon.
The Sequence function does not populate in my version of Excel. I wonder why? I guess it is only avail to Microsoft 365 licenses. Dang.