From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Identify odd-numbered teams

Identify odd-numbered teams - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Identify odd-numbered teams

“

- [Instructor] Here's a challenge that might seem easy on the face of it, but there are some snakey things to deal with, and I hope you have your boots on and your long gloves so that you don't get bitten by the little snakes in here. We've got a column of project names and the members. We want to identify projects that have an even number of members, and if there are zero members, then stay blank. We want to know if they have more than nine people, and fewer than four people. And yes, for the Sprinter project, we do want to know that they do have fewer than four people. And how you identify 'em of course is up to you. Pause the video, work that out. (upbeat music) (music fades) Let's get into it. And anybody who does not have their boots, they need to stand back while we work out these snakes here. So here I'm going to make an "even" column, and then a "less than four" column, and a "greater than nine" column…

Contents