Excel 2003: Match Names; View Unfound Matches

99cateyes - Feb 18, 2009 at 08:41 AM
 99cateyes - Feb 18, 2009 at 10:51 AM

I need formula or macro configuration help for Excel 2003.

Within a spreadsheet, I want to compare the list of names in column A with the list of names in column B and be notified of matches that were NOT found. The scenario is:

- I have a list of people in column A that must attend a training course
- I have a list of people in column B that attended that course
- I want to compare names in A with B so that I can see which people did not attend that course when they should have. I need Excel to visually show me which matches were not found and ideally extract those names into another sheet or into a list in a pop-up message or something that allows me to select and copy those names.

How do I do this in Excel? Is there a macro I could configure to automatically perform this match?

Thank you in advance for your help!

2 responses

Tweedledum Posts 181 Registration date Monday January 19, 2009 Status Member Last seen April 2, 2009 125
Feb 18, 2009 at 10:42 AM
Awesome! Thank you very much!