SEQUENCE is definitely a powerful new function. Thanks for all the examples. Thumbs up!
@janidr
3 жыл бұрын
So simple. The way you explain formula step by step...Salute Sir
@ramesha1974
4 жыл бұрын
Learned something new in excel today from you. Thanks
@TeachExcel
4 жыл бұрын
I'm glad to hear it! You are very welcome!
@IvanCortinas_ES
4 жыл бұрын
Thank you for the tutorial. Very useful!
@TeachExcel
4 жыл бұрын
You're very welcome Ivan! I'm glad you found it useful :))
@jesuspalalia5164
4 жыл бұрын
Genius pure genius
@TeachExcel
4 жыл бұрын
:)
@darrylmorgan
4 жыл бұрын
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
4 жыл бұрын
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
@kebincui
Жыл бұрын
Awesome👍
@excelworx8712
4 жыл бұрын
absolutely marvellous!
@TeachExcel
4 жыл бұрын
I'm glad you think so! Thanks :)
@avrahammaymon7975
3 жыл бұрын
tnx so must you help me a lot so esay learn with you :)
@prasanthprasad4126
3 жыл бұрын
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
4 жыл бұрын
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
4 жыл бұрын
Thanks) You could do something like this: =INDEX({"a","b","c"},SEQUENCE(3))
@cabecao311
4 жыл бұрын
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
@onesimonkomo2885
3 жыл бұрын
Can i get a formula to calculate the next numbers in the incrimental values. The first and last columns are fixed.
@mikelennon1078
3 жыл бұрын
If I have an Excel 365 workbook with new functions like "Filter",....... does this workbook work/function on Excel 2019 as well?
@harshadhpatel11
4 жыл бұрын
very nice
@صقر_الجزيرة
3 жыл бұрын
well done 👍
@Bourouwe
4 жыл бұрын
Definitely very useful, thank you!
@TeachExcel
4 жыл бұрын
Glad you think so) You're welcome!
@xbubbleteenx
4 жыл бұрын
Thank you
@TeachExcel
4 жыл бұрын
You're welcome! I'm glad you like it :)
@37777steve
3 жыл бұрын
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
3 жыл бұрын
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
4 жыл бұрын
AGREAT TUTORIAL.VERY INFORMATIVE WITH NEW CONCEPT. PLEASE ALSO TELL US HOW TO INCREMENT YEAR AND/OR MONTH IN SEQUENCE MODE.
@TeachExcel
4 жыл бұрын
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
4 жыл бұрын
@@TeachExcel great. Thanks
@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.
@tamjacqueline8237
2 жыл бұрын
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.
@crazy2cu25
4 жыл бұрын
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
@r.krishnan7155
4 жыл бұрын
Is any alternate to sequence function ?
@LotfyKozman
Жыл бұрын
Why results become corrupted when the incremental step is 3 months when using the EOMONTH()?
@sansl3
4 жыл бұрын
What about time? I have to make schedules with time and minute increments.
@TeachExcel
4 жыл бұрын
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
@mrjenk0073
3 жыл бұрын
How can I get series from i.e. 44NA001 to 44NA050..
@TeachExcel
3 жыл бұрын
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
3 жыл бұрын
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
@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
@redhaakhund1271
3 жыл бұрын
⭐️⭐️⭐️⭐️⭐️
@tanzimkhan5100
2 жыл бұрын
Not working in Excel 2019
@FriendofAtlas
2 жыл бұрын
I thought I was the only one that used the old alt codes, lol
@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
Пікірлер: 47