From the course: Excel: Using Dynamic Array Functions (Microsoft 365)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Basic SEQUENCE

Basic SEQUENCE

From the course: Excel: Using Dynamic Array Functions (Microsoft 365)

Start my 1-month free trial

Basic SEQUENCE

“

- ([Instructor]) Here's something cool that we just started. We're going to go visit a different friend, every other Tuesday, starting on the 11th of June, 2019. Now we need the dates so that then, we can start filling in a list of who we're going to visit and when. We're going to use sequence. Start here at the visit date, equals sequence, double click. Now it wants to know how many rows of dates we need. I'm going to count A in that table. Count A, open parentheses. We want this column, I like that. Close the count A, comma. We want just one column, comma. Where do we want to start? We want to start on this number, comma. How many steps? We're going to be doing this every other week. So we want to step 14, close parentheses, enter. There are our dates. Notice that some of the results start with 43 thousand and something. That's Excels own notation for keeping up with dates. When it does calculations, it's doing it with something like 43,641. We just need to change the format. I'm…

Contents