SEQUENCE() Function for Power List Making in Excel 365

[@wayneedmondson1065]

SEQUENCE is definitely a powerful new function. Thanks for all the examples. Thumbs up!

[@janidr]

So simple. The way you explain formula step by step...Salute Sir

[@ramesha1974]

Learned something new in excel today from you. Thanks

[@TeachExcel]

I'm glad to hear it! You are very welcome!

[@IvanCortinas_ES]

Thank you for the tutorial. Very useful!

[@TeachExcel]

You're very welcome Ivan! I'm glad you found it useful :))

[@excelworx8712]

absolutely marvellous!

[@TeachExcel]

I'm glad you think so! Thanks :)

[@avrahammaymon7975]

tnx so must you help me a lot so esay learn with you :)

[@jesuspalalia5164]

Genius pure genius

[@TeachExcel]

:)

[@kebincui]

Awesome👍

[@onesimonkomo2885]

Can i get a formula to calculate the next numbers in the incrimental values. The first and last columns are fixed.

[@r.krishnan7155]

Is any alternate to sequence function ?

[@Bourouwe]

Definitely very useful, thank you!

[@TeachExcel]

Glad you think so) You're welcome!

[@mikelennon1078]

If I have an Excel 365 workbook with new functions like "Filter",....... does this workbook work/function on Excel 2019 as well?

[@صقر_الجزيرة]

well done 👍

[@darrylmorgan]

Great Tutorial!I've Taught The Finance Manger In Work How To Use SEQUENCE() Along With Paste Special Needless To Say I'm Her Favourite Colleague lol..Thank You Sir :)

[@TeachExcel]

I'm glad you think so Darryl, thanks!! And that is great, but be careful letting them know how much you know or you will be the "Excel Guy" who has to do all the vlookups for them forever lol

[@cabecao311]

Awesome feature!!!!! Is there a way to have a 2 figures format when sequence is less than 10 (01 instead of 1, 02 instead of 2,...)? Thanks

[@tamjacqueline8237]

Hi, can I seek for your advise, why my sequence formula is not working. I am using Microsoft Home 365 - version 2019 , window 10 Home Still not working.

[@37777steve]

In your last example, you typed spaces in your formulas and they still worked. I thought you could only do that inside quote symbols. Is this something new or have I just missed this for years?

[@TeachExcel]

If you like that, try putting the cursor before each argument and hitting Alt + Enter to space out larger formulas and make them easier to read! :) And maybe you just missed this or maybe not, Excel changes so quickly now that I can't remember what works on every version anymore, so maybe spaces weren't allowed in some past versions?!

[@rajeevgosavi4514]

AGREAT TUTORIAL.VERY INFORMATIVE WITH NEW CONCEPT. PLEASE ALSO TELL US HOW TO INCREMENT YEAR AND/OR MONTH IN SEQUENCE MODE.

[@TeachExcel]

You could do it like this: =DATE(SEQUENCE(5,1,2020,1),1,1) If that doesn't help, include more info and ask in the forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@rajeevgosavi4514]

@@TeachExcel great. Thanks

[@prasanthprasad4126]

Thank you for the tutorial. Very useful! pls, could you tell me the formula how to arrange same date in 16 rows and increment date same in 16 rows like

[@randyrobertson6093]

Neat trick good explanation Now how would you do a sequence of characters (not Barney, Fred, Wilma, and Betty, but A, B, C, etc.......)

[@TeachExcel]

Thanks) You could do something like this: =INDEX({"a","b","c"},SEQUENCE(3))

[@dorianolara]

I have a old datebase of 2 team playing each other. The datebase cointainse, the dates and the scores of all time. I am trying to make excel indetify a 3 day series sequence such as , 4/1/2019, 4/2/2019, 4/3/2019 and delete a 4 series games for example 5/1/2022, 5/2/2022, 5/3/2022, 5/4/2022.

[@mrjenk0073]

How can I get series from i.e. 44NA001 to 44NA050..

[@TeachExcel]

Make the 1 to 50 in a separate column and combine that column with the required text using CONCAT() or just combining the values in a small formula.

[@TeachExcel]

Note that I will probably not see a reply to my comment so if you still require a bit of help, feel free to ask in our forum. TeachExcel Forum: www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@harshadhpatel11]

very nice

[@crazy2cu25]

Pls. could you tell me how to arrange mixed 4 and 5 digits in excel. I tried to use text function but a number with text didn't change

[@LotfyKozman]

Why results become corrupted when the incremental step is 3 months when using the EOMONTH()?

[@xbubbleteenx]

Thank you

[@TeachExcel]

You're welcome! I'm glad you like it :)

[@sansl3]

What about time? I have to make schedules with time and minute increments.

[@TeachExcel]

Depends how you want to increment it - maybe sequence isn't the best option for this. Include a sample file or more specifics with your question and ask in our forum and its easier to help: www.teachexcel.com/talk/microsoft-office?src=yt_comment

[@tanzimkhan5100]

Not working in Excel 2019

[@jienasiqiaoyi8258]

My excel don't have SEQUENCE function🤔 Please help me out.

[@TeachExcel]

Hi, please ask in our forum and provide more specific information on what you are trying to do. Sequence is only in newer versions of Excel, infortunatly. www.teachexcel.com

[@FriendofAtlas]

I thought I was the only one that used the old alt codes, lol

[@redhaakhund1271]

⭐️⭐️⭐️⭐️⭐️

[@kondurimanikanta7763]

AZ10 # HZ11 HZ11 # Connector one HZ11 # Connector two HZ11 # AZ11 Centre joint AZ11 how to Repeat above sequence by just incrementing 1 for numbers