Excel 2003: Match Names; View Unfou

February 18, 2009 at 06:44:28
Specs: Windows XP

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!

See More: Excel 2003: Match Names; View Unfou

Report •

February 18, 2009 at 08:28:28
This solves part of your problem:

1. Insert a column between
Column A (Scheduled to Attend)
Column B (Actually Attended)

2. Type the following formula in cell B1:

=IF(ISERROR(MATCH(A1,$C$1:$C$150,0)),"No Match in Col C","")

3. Select cells B1:B150
4. Then "Edit", select "Fill" on the Edit menu, and then click “Down”.

This will compare who was scheduled (Column A) against who atteneded (Column C)and insert the comment "No Match in Col C" next to the name in Column A it could not find.

The columns do not have to be sorted, although it might be easier.
I Started at Row 1, change the formula if needed.
I used only 150 rows to check, again change if needed.
I inserted a column, because I find it makes it visually easier to determine the outcome.


Report •

February 18, 2009 at 08:37:40
It works! Thank you so much Mike. (:


Report •

Related Solutions

Ask Question