From the course: Excel: Advanced Formulas and Functions

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Challenge 5: Home selection

Challenge 5: Home selection - Microsoft Excel Tutorial

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Challenge 5: Home selection

“

(bright music) - In this challenge, we are looking at homes. These addresses represent a section of a city where we know that homes that have an even number, they get the best sunsets. Odd number addresses, they get a beautiful view of the skyline and the nightlights. We want to create a dynamic solution that will identify the odd numbered addresses. And to ensure that it's dynamic, add some made up addresses once you've got your solution and make sure that everything updates. (upbeat music) Let's get started. I'm going to name this, let's say Odd/Even. Now, I need to peel away the address number from the full addresses. But first, let's format as table. Let's grab this purple. Table has headers. Okay, no filter buttons. Let's start. Equals text before, double click. Text the homes, comma the delimiter. Double quote space, double quote. I'm not concerned about the instance number or anything else.…

Contents