From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Fix IDs

Fix IDs

- [Instructor] Hazel King just called and she is angry. She just found out that she's on probation. Well, as shown in our list. But because enough people have called we've realized, wait a minute, R42645 is on probation. And we go to the master list, we see R42645 is Loretta Bell. But Loretta Bell, over in our list, she shows a bonus. But that really belongs to J33854, who in the master list is Martin Peacock. This is a mess. And this actually happened to me. It was spooky. So anyway, our objective in the actual ID column, in our list, match these people up with the right ID. And then in the check column, make an X everywhere that the two IDs do not match. 'Cause we got to get out of trouble here you all. All right when you're ready pause the video, pull up the exercise file, and I'll be ready for you to straighten this out when you come back. All right you're back, let's get this straightened out before Hazel King comes over here and it won't be pretty. First of all, put these…

Contents