How to Use the Excel SEQUENCE Function

[@nicho4782]

Thank you!

[@MyExcelOnline]

You're welcome!

[@dineshrddy]

Thanks, it is really good explanation.

[@MyExcelOnline]

Thanks! Glad you liked it!

[@djnexus2305]

hello can you give us a alternativ without seq function? Because i have a older version

[@MyExcelOnline]

You could try autofill. Establish your pattern by typing in 1 in the first cell, 2 in the second, and so on (you could also do 10, 2, 30, etc) and then highlight those two or three cells and hover over the box on the bottom right hand corner of the cell and drag down to autofill. Hope that helps!

[@-theflea-4561]

I think that tarantula should not be a pet

[@MyExcelOnline]

I agree! Snakes should be out as well....

[@davidlL714]

Hello, I frequently use an ordinal column to maintain the original order that data is inputted into the spreadsheet. Let us say I perform a sort on a different column, and it changes up all of the rows. and I want to go back to original order, will the =SEQUENCE function automatically rearrange its number onto the sorted part thus losing my original order? I hope this makes sense. Please ask for clarification if I am not clear. Sincerely

[@MyExcelOnline]

Hi. Great question! I would recommend doing a copy then paste values on the sequence column before sorting in order to maintain the original number. You will not be able to add more in the sequence later on, but hopefully this still helps.

[@dannoohio]

Is it possible to skip rows and put the sequence in every-other row?

[@MyExcelOnline]

I do not believe so.

[@SatyamYadav-ih1id]

Is there any way to write this using autofill 5 to 10 11 to 15 16 to 20 And so on

[@MyExcelOnline]

I think in that case if you started with 5 and did 6 then 7 in the cells below and then did Autofill, it should copy those numbers down.

[@bonbon1199]

Is there in any way if the sequence is from 1 to 10 and if I input a number 5.5 it will be automatically placed between 5 and 6?

[@MyExcelOnline]

Thanks for the questions. In order to sequence 1-10, use this formula =SEQUENCE(10,1,1,1). I don't think SEQUENCE lets you input a number. If you would like .5 numbers (5, 5.5, 6, 6.5, etc) then use .5 in the step argument. Hope that helps.

[@TepidTurtle4]

How would type the arguments of the sequence function if I wanted to number 5000 rows starting at 1 and stepping by 0.01?

[@MyExcelOnline]

You could try this: =SEQUENCE(5000,,,0.01)

[@TepidTurtle4]

@@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

[@MyExcelOnline]

That's great!

[@AshrafAli-ig1nl]

Sequence function is absent in 2007 and 2010 , I can add to them or not?

[@MyExcelOnline]

I think you do need Excel 365.

[@AmySanford-jc3di]

Is there a way to use the sequence formula but skip every other column?

[@MyExcelOnline]

I don't think so. But you could get creative maybe with an IF statement also in there?

[@MyExcelOnline]

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?

[@ddp2049]

Hello why when using the sequence formula in a table there is a spill# error.👎 Please help if you can thanks

[@MyExcelOnline]

I'd recommend downloading our sample file in the link in the description on KZbin and comparing it with the copy you are using. Sometimes it's a little difference in the formula. Hope that helps!

[@ELIZABETHOWITI-254]

What of text number sequence

[@MyExcelOnline]

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.

[@ELIZABETHOWITI-254]

@@MyExcelOnline thank you

[@MyExcelOnline]

You're welcome!

[@jamespressman1202]

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.

[@MyExcelOnline]

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.

[@jamespressman1202]

Why for me when i type= sequence no recommend "Sequence" word pop up alongside with the rows,columns etc?

[@MyExcelOnline]

Hi. Great question. What version of Excel are you using? This function works with Office 365.

[@lIlIlIlIlIlIlIl]

@@MyExcelOnline The same problem. When I go to updates, I find that Excel is running the latest version

[@MyExcelOnline]

Are you able to type =Sequence and put the arguments in without it popping up?

[@alexanderhmaniwang]

I can't find the "Sequence formula" maybe my 2013 office has not built in formula on it.

[@MyExcelOnline]

Thanks for the question. Yes, you are correct, it's available in later versions of Excel. We use Excel 365 in our videos.

[@Adriaan.J.L]

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?

[@MyExcelOnline]

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

[@Rk-bh7ru]

how start new serial for every new class..

[@MyExcelOnline]

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?

[@1000frolly]

I want to make a sequence in rows LIKE THIS; AAA AAB AAC AAD AAE AAF AAG.......AAX AAY AAZ ABA ABB ABC ABD and so on. How can I do this?

[@MyExcelOnline]

Thanks for the question. You could try putting in AAA into row 1, AAB into row 2, AAC into row 3 and then highlighting all of them and dragging down to see if Excel senses the autofill pattern. Hope that works!

[@1000frolly]

@@MyExcelOnline No it just repeats AAA AAB AAC.

[@MyExcelOnline]

In that case, it would most likely take a macro to do what you want to accomplish.

[@dograsirclasses]

Sequence function is not working in pc

[@MyExcelOnline]

Hi. So sorry to hear that. Are you using Excel 365?

[@angulyabharnammadhusudhan1940]

Sequence function is absent Office 2019

[@MyExcelOnline]

Yes. Maybe consider 365? The XLOOKUP function makes it worth it!

[@bell581]

Why do I get #SPILL! ☹️

[@MyExcelOnline]

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.