From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Repeat a pattern

Repeat a pattern - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Repeat a pattern

“

- [Instructor] This is going to challenge how efficient you are. We've got three columns. We've got day one, two, three, that needs to go down to 21, and don't retype these. You've got to know how to do this, all right? In the weekdays, take that all the way down to day 21, but keep this pattern, Monday, Tuesday, Wednesday, Monday, Tuesday, Wednesday. Repeat like that. We don't want to see Thursday, Friday, Saturday, Sunday in here. And then the assigned column. We want Jean, Constance, Erika, Zoltan, Mia, and then start again, Jean, Constance, Erika, et cetera, all the way to day 21. And then finally, identify any instances where Constance is assigned on a Wednesday. And you get to highlight or flag that however you want, all right? Pause the video, make this list, come on back and I'll get it done. Right, here we go. I'm going to highlight one, two, three, and I can just drag this down and notice that…

Contents