- ([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. …
AuthorOz du Soleil
- Working with spills
- Using the UNIQUE function
- Sorting with dynamic arrays
- Comparing SORTBY and SORT
- Unstacking records with SEQUENCE
- Creating intelligent filters
- Randomizing data with RANDARRAY
- Combining dynamic arrays in drop lists and more
Skill Level Advanced
1. What to Know Before Using the New Functions
Warnings to heed6m 19s
Horizontal SORT3m 33s
9. Putting It All Together
10. Challenges and Solutions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.