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.
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.
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. ❤
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.
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.
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.
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❤❤❤
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?
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?
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! 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?
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?
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.
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.
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
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! 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?
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
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 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
Is there a way to contact you directly? I need help creating a sequence with breaks that insert a comment from another cell, but not lose the overall sequence count.
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?
Sequence function will not handle that, but this will work. Click A2 and type 1. Click A3 and type 1. Click A4 and type =A2+1. Autofill down. Screenshot drive.google.com/file/d/156HrGYwQGiFW6AjbPgAJZXN2IGemhwaa/view?usp=drivesdk
Great feature and would save a lot of time, but doesn’t seem to work in tables. If I convert my table to a range, it works fine, but not in the large tables I use daily.
Do the sequence for 456, 457, and so on in one column. In another column, have 2023-24 and autofill down. Now, add a helper column and concatenate the first two columns. =A2&/"&B2 drive.google.com/file/d/1ek8AMY6RCtzszGhk7iNkfN8GZYA-NaAO/view?usp=drivesdk
I didn't read all the comments but it did not work for me. Sequence works well in google sheets but I am using Office Professional 2010 and I have no populated SEQUENCE function and after typing it in, it still does not work. Any ideas?
I have a table where i have same types of data in a column and i want all those data in next column in a serial format. for example 123456 123456 123456 in a column and i want 123456 1 2 3 in next column. just because 123456 3 times. if another data 654321 654321 654321 654321 4 times then data in next column 654321 1 2 3 4. Please share any formula available.....
I've always known there is a better way than 1, 2, select, drag but never knew what else to do. This is great!
Thanks I needed this. Also you are a great teacher
Thank you!
Your instructions are great because you get right to the point and you keep it simple.
Thanks for showing different ways to add numbers. Thanks
Happy to help
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!!!!!!!
so much to learn sir. thank you!
I've always thought there has to be a better way to fill in numbers. Awesome. Thanks
You bet!
Chris. I like your tutorials, they are clear and fun to watch 👍
I appreciate that!
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.
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.
Perfect! I was looking for just this type of functionality. I'll be using this from now on. Thanks, Chris!
Thank you, Chris! Very helpful. I knew there was a way to have the sequence automatically update. Enjoyed the video!
I like the sequence funcation and have already added it into some of my spreadsheets. Thanks!
You're welcome!
Was struggling to find out how to do this. Came across your video and figured it out immediately! Thank you
You are welcome!
I have learnt a lot from you today
Thank you!
I will use this feature. Thank you again Chris!
Thanks, Irving.
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.
Nice presentation and good examples. I am going to use the sequence (count function). Thank you.
Yes, this is new to me. I used the fill method most often, I will try this one now.
Thanks, Lorenzo.
Thank you so much sir! This was very helpful
You are welcome!
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. ❤
Thank you very much this saved me so much time on a report!
Glad it helped!
Definitely utilizing this.
Thank you. This is very helpful.
You're welcome!
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.
This is great,,, I just used it and it works wonderfully! This channel is great!
thanks for this one
You're welcome
Fantastic !!! Thank you
Thank you very much Chris.
You are very welcome
Thank you excellent tutorial
Well., ur method of explaining is very good, and experience speaks❤
I definitely use this function. Thanks.
Thank you, you made it so easy
Glad to hear that! Thank you.
great info! very useful! thank you❤
I am definitely going to use that. Thanks.
Thanks, Johnny.
I also didn’t know about this. Great way to do it.
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.
Thank you, I love new ideas
You are so welcome!
thanks, good way to sequence columns!
I will be using option #5.Thank you Much.
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 salute you bro. Thanks bro. You are the answered to my prayer! :)
My pleasure
Thank you made this task so easy for me a novice user
Cool brother
Thanks from India❤
Welcome!
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.
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!
That's our guy. Thank you.
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?
Super Cool!! TY.
Welcome.
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?
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.
good stuff. thank you
You bet. Thanks, Robert.
Great info
TY!
its really helpful
Thank you!
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?
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?
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.
awesome thanks
You bet!
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.
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.
Thanks!
Welcome!
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
Great. I have a question when you have the sequence function in excel table is there a specific to write the formula
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 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?
thank you
You're welcome
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?
Hey Chris, there might be an easier option try using "=row()"
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
GREAT
happy to help
I have specific lists. Can I add a row within a list and renumber automatically?
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.
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
the best
The last one worked but when I filter out cells, the sequence does not correct itself?
Hello sir, how to ad that function sequence in excel please ? I don't have it in my function list !
The SEQUENCE function only works with Microsoft 365 accounts and Excel 2021 and Excel for the web.
@@ChrisMenardTraining Many thks sir! will change my office version! thks again !
Is there a way to contact you directly? I need help creating a sequence with breaks that insert a comment from another cell, but not lose the overall sequence count.
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.
What if you want to sequence filtered rows?
I do not believe that will work with Filters.
Another not-so-great mentioned:
A1 = "1"
A2 = "A1+1", pull down. Breaks down when deleting row.
I want to make a sequence LIKE THIS; AAA AAB AAC AAD AAE AAF AAG.......AAX AAY AAZ ABA ABB ABC ABD and so on. How can I do this?
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?
May i ask sir, why do when i did the =SEQUENCE(31 or any number it automatically become date 1-Jan on sequence?
I want my series of numbers to be like 1,1,2,2,3,3 and so on. How would I do that.?
Sequence function will not handle that, but this will work. Click A2 and type 1. Click A3 and type 1. Click A4 and type =A2+1. Autofill down. Screenshot drive.google.com/file/d/156HrGYwQGiFW6AjbPgAJZXN2IGemhwaa/view?usp=drivesdk
I'm using WPS, I don't have a sequence function, but, the row function, the row number minus 1 smaller, say 13-12, row()
Great feature and would save a lot of time, but doesn’t seem to work in tables. If I convert my table to a range, it works fine, but not in the large tables I use daily.
I try to use sequence(counta(b:b)), but the value is NAME?
how to start a sequence inbetween like
456/2023-24
457/2023-24
458/2023-24 and so on" can u help me with this???
Do the sequence for 456, 457, and so on in one column. In another column, have 2023-24 and autofill down. Now, add a helper column and concatenate the first two columns. =A2&/"&B2 drive.google.com/file/d/1ek8AMY6RCtzszGhk7iNkfN8GZYA-NaAO/view?usp=drivesdk
thank u so much...this helps me save lot of time @@ChrisMenardTraining
WHY DONT APPEAR THAT FUNCTION IN MY EXCEL what version are you working?
I didn't read all the comments but it did not work for me. Sequence works well in google sheets but I am using Office Professional 2010 and I have no populated SEQUENCE function and after typing it in, it still does not work. Any ideas?
Unfortunately, is it not available for Excel 2010. You need an M365 subscription.
I have a table where i have same types of data in a column and i want all those data in next column in a serial format. for example 123456 123456 123456 in a column and i want 123456 1 2 3 in next column. just because 123456 3 times. if another data 654321 654321 654321 654321 4 times then data in next column 654321 1 2 3 4. Please share any formula available.....
This won't work in an excel table because of the #spill problem when the formula is automatically copied down
I tried =SQUENCE (B2:B40 enter and it doesn't work?
what excel version are you using?
@@ChrisMenardTraining Microsoft 365
using in Singapore at therapy department
I didn't know how to add a column to get started. Lol
row-1
seq and seq with counta don't work if you have hidden rows.
True