Thank you! Short and simple (just what I need at my age) Plus, enjoyed your assistant, what a cutie! She kept me smiling.

@ApexTrainingLLC

2 жыл бұрын

Thank you Dianne! In all my years of training people on Excel, I've found work ethic and curiosity are the determining factors for success, not age :-)!

Thank you , this is a practical use for it. If you have other real live examples of situations when you would use it would be great.

@ApexTrainingLLC

Жыл бұрын

kzread.info/dash/bejne/qXiJq9uJj5bRiaw.html

This would come in handy when you design a WAN with multiple "class C" private IP addresses for the Ethernet LANs and to split arrays of ".252" masks for the WAN IPs.

@ApexTrainingLLC

Жыл бұрын

Agreed!

Thank you for the learning...

@ApexTrainingLLC

Жыл бұрын

My pleasure

what if the excel version does not have "sequence" command, what should I use?

@floresdecetim

2 жыл бұрын

Try to translate to your own language what "sequence" means. And try. For example. For me was "Reeks" in Dutch.

@deepjyotistories

2 жыл бұрын

Same query here.

Hi my Excel dont hace that funcion what can i do?

Thanks professor

@ApexTrainingLLC

4 жыл бұрын

You're welcome K mac1 ... let me know if there are any specific functions you'd like to see

@alangokenn2092

Жыл бұрын

My 2013 office doesn't have the Sequence function

Very nice sir

@ApexTrainingLLC

3 жыл бұрын

Thank you!

Thank you very helpful sir how can do it with old excel 2010

@ApexTrainingLLC

Жыл бұрын

Not available in 2010

Re the SEQUENCE function: please open a new sheet, create a vertical 1 x 10 Excel table (with header) with arbitrary numbers in cells A1 through A10. Then enter "=SEQUENCE(9)" in cell B2 and hit return. Results in a complete mess in my case. Instead of just executing the SEQUENCE function, it extends the table in A1:A10 to the right and populates it with #SPILL! errors. Does anybody else observe that, too? Is this a known issue?

@ApexTrainingLLC

Жыл бұрын

I'll try it.... I'll let you know if I can replicate that issue

Unable to use SQUENCE code. Function Not available in Excel 2010. Please Help

Hi Rich. Can I use this function to sequentially create serials number like 001/100 through 100/100? I need to increase the first number not the second one. Thanks!

@ApexTrainingLLC

11 ай бұрын

Hi Santia. Yes you can. Use the sequence function for the first part, then use the "&" symbol to combine with "/100"

@ApexTrainingLLC

11 ай бұрын

I'll set up an example

@JoshSpace

11 ай бұрын

@@ApexTrainingLLC thank you.

Can you please sir help in sequence in excel. I wanna create a series like 44CA001 ......to 44CA050.

@romeocostillas

3 жыл бұрын

="44CA"&text(sequence(50,1,1,1),"000")

how to use sequence(countif)? im in a middle of making a household profiling in excel and i want: when i put "HEAD" it will give me No. 1 and succeed to No. 2 and so on =IF(M8="","",IFERROR("No."&SEQUENCE(COUNTIF(M8,"HEAD"),1,1,1),"")) but it doesnt work the way i want it to work, its stuck in No. 1 please help me.

@ApexTrainingLLC

Жыл бұрын

Check it out! kzread.info/dash/bejne/onyuqsmIddi8lKw.html

There is no formula in my excel ? Why ?

@ApexTrainingLLC

Жыл бұрын

You need to update to the latest version...

@vishnudas380

Жыл бұрын

@@ApexTrainingLLC yeah i got it, thank you : )

I have no =sequence() in my excel. How?

@ApexTrainingLLC

Жыл бұрын

You need the most recent updates to office 365.

How can i do it like this? For example: I have 5 employees i want to distribute the cases among them like i have 25 cases Emp 1-1 to 5 Emp 2- 6 to 10 Emp 3-11 to 15 Emp 4-16 to 20 Emp5- 21 to 25 How can i do it in excel using which function.?

@ApexTrainingLLC

7 ай бұрын

Great question, I will do an example.