How to Use the Excel SEQUENCE Function
HTML-код
- Опубликовано: 25 июл 2024
- In this tutorial, we will teach you how to use the Excel SEQUENCE function. First, we will show you what not to do when creating a sequential number column in Excel. Next, we will show you how to use the SEQUENCE function to create a numbered column that retains its values, even when adding or deleting rows. Then, we will show you some of the optional arguments for the Excel SEQUENCE function, including the columns, start, and step arguments as well as how to transpose any of the SEQUENTIAL data. This is a great video for any level of user wanting to learn how to use the Excel SEQUENCE function.
Download the sample file used in How to Use the Excel SEQUENCE Function here: www.myexcelonline.com/wp-cont...
How to Use the Excel SEQUENCE Function Time Stamps ⌚
00:00 - Introduction to How to Use the Excel SEQUENCE Function
00:25 - What Not to Do When Creating a Numbered Column in Excel
02:28 - How to Use SEQUENCE Function to Make a Numbered Column in Excel
03:29 - How to Use the Optional SEQUENCE Function Columns Argument in Excel
04:14 - How to Transpose the SEQUENCE Function in Excel
04:36 - How to Use the Optional SEQUENCE Function Start Argument in Excel
05:01 - How to Use the Optional SEQUENCE Function Step Argument in Excel
05:37 - Conclusion for How to Use the Excel SEQUENCE Function
------------
🔥 OUR BEST EXCEL RESOURCES 🔥
👨🏫 Get 30+ Excel & Office Courses & support for ONLY $1💵 (all levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!
Join Now for ONLY $1 (limited time offer) 👉 www.myexcelonline.com/107-186...
📚 Download Our Free 101 Excel Tips & Tricks E-Book:
Download for FREE 👉www.myexcelonline.com/101-exc...
💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:
Access for FREE 👉www.myexcelonline.com/107-3.html
📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:
www.myexcelonline.com/107-59....
📚101 Most Popular Excel Formulas Paperback on Amazon:
www.amazon.com/dp/1700300911
📚101 Ready To Use Excel Macros Paperback on Amazon:
www.amazon.com/dp/1700729675
📚101 Best Excel Tips & Tricks Paperback on Amazon:
www.amazon.com/101-Best-Excel...
👷 Excel Consulting Services:
www.myexcelonline.com/microso...
💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
www.youtube.com/@MyExcelOnlin...
------------
Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)
Cheers,
JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
www.myexcelonline.com/
❤️ Let’s connect on social ❤️
LinkedIn: / johnmichaloudis
Instagram: / myexcelonline
Pinterest: / pins
Facebook: / myexcelonline
Twitter: / myexcelonline
#MyExcelOnline #SEQUENCE #Functions #Excel #MsExcel
Thanks, it is really good explanation.
Thanks! Glad you liked it!
Is it possible to skip rows and put the sequence in every-other row?
I do not believe so.
How would type the arguments of the sequence function if I wanted to number 5000 rows starting at 1 and stepping by 0.01?
You could try this: =SEQUENCE(5000,,,0.01)
@@MyExcelOnline thank you so much. I ended up writing a vba function to do this but I knew there had to be an excel function to do the same thing
That's great!
Sequence function is absent in 2007 and 2010 , I can add to them or not?
I think you do need Excel 365.
I wan to display a sequence by 2 like 2 4 6 8 10 but instead it display 2 3 4 5 6 7 8. Where did i go wrong? I ctrl drag 2 and 4 in order to sequence it.
Thanks for the question! For the 4th argument (it's an optional one), use a 2. So if I had one row and wanted it to be 2-4-6-8-10, I would use this function: =SEQUENCE(5,,2,2). Try pasting that into Excel and see if it works for you.
Why for me when i type= sequence no recommend "Sequence" word pop up alongside with the rows,columns etc?
Hi. Great question. What version of Excel are you using? This function works with Office 365.
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 think for this, you may need to use VBA and do a loop that will loop. So you could set a counter for 1-18 and then loop 18 times. So something like this:
Dim intCounter As Integer
Dim intRepeat As Integer
Dim rngCurrentCell As Range
Set rngCurrentCell = Range("A1")
intCounter = 1
Do Until intCounter = 19
intRepeat = 1
Do Until intRepeat = 9
rngCurrentCell = intCounter
intRepeat = intRepeat + 1
Set rngCurrentCell = rngCurrentCell.Offset(1, 0)
Loop
intCounter = intCounter + 1
Loop
Hello why when using the sequence formula in a table there is a spill# error.👎 Please help if you can thanks
I'd recommend downloading our sample file in the link in the description on RUclips and comparing it with the copy you are using. Sometimes it's a little difference in the formula. Hope that helps!
What of text number sequence
Hi. Thanks for the question. I think the Sequence function only takes numbers and not letters. You could put A in one cell, B in the next, then C in the next and then select all three and drag down and you should get D then E then F, etc.
@@MyExcelOnline thank you
You're welcome!
how start new serial for every new class..
Hi. Thanks for the question. You can change the arguments for SEQUENCE whenever you would like. Maybe try doing each class on a different tab?
Is there a way to use the sequence formula but skip every other column?
I don't think so. But you could get creative maybe with an IF statement also in there?
I don't think any of the arguments for SEQUENCE handle that, but you may be able to get creative with an IF statement in there. Or maybe the COLUMN function? Or both?
Sequence function is absent Office 2019
Yes. Maybe consider 365? The XLOOKUP function makes it worth it!
Why do I get #SPILL! ☹️
Thanks for the question. #SPILL! usually means the formula is returning multiple values and wants to spread out into more cells. Do you have empty cells next to where you are using the formula? Try the formula out on an empty [art of your spreadsheet and see if that helps.