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.

Isolate data by the week

Isolate data by the week - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Isolate data by the week

“

- [Instructor] Here we've got this long list of visitors. Let's scroll down and see how long it really is. Goes down to row 170. Here's what we need to do. We've got the dates and the names. Identify everybody who visited weeks 18, 19, and 20. List those people on a new worksheet. Remove any duplicate names and then match each person with their email address. The email addresses are over here. If we don't have an email address for a person, don't leave an error. Please insert a capital X. Pause the video, worked it out, come back and I'll show you how it's done. Okay, let's do it. Put my cursor in the dataset. I am going to convert this into a table. Let's pick this orange here, okay? Next I'm going to make a weak column equals weak. Weak numb is the function we want. What is a serial number? That date, and then I'm going to hit okay, and I've got a format this as a number. When a highlight the column, go to…

Contents