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.

Identify multiple shifts

Identify multiple shifts - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Identify multiple shifts

“

- [Instructor] We've got a great group of people who work for us. And we do not want to work them too hard because they'll get miserable and quit. So we want to dig into something. And that's where your help is needed. Here we've got all of the shifts from every day in May 2018. Identify any days where one person worked more than once. Notice that on the 10th of May, Bonnie opened, Bonnie closed. That's the kind of day that we need flagged or identified. And then get an overall count of how many times this has happened in May of 2018. All right, pause the video, get that calculated, come back, and I'll show you how I figure it out. Okay, you're back. Let's see what's happening. I'm going to put my cursor in the data set and put it into a table. Let's go with this turquoise. Okay. Don't need the filter button. I'm going to go here and I'm going to use the unique function, equals unique. Double click. What is the…

Contents