Hello,
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!
Advanced filter excel 2003 Auto and advanced filter on same range excel 2003 Excel 2003 & match formulae Excel 2003 asks for password converter 2007 Excel 2003 cell reference in cell Excel 2003 copy cell to different worksheet Excel 2003 filter row contains Excel 2003 import mdb download vba Excel 2003 replace 1 character Excel 2003 vba count unique cells Excel 2003 vba sql database report free samples How to count the numbers of use cell in excel 2003 If function in excel 2003 Looking up data in excel using match More than 3 conditional formats excel 2003 Ms excel 2003 formulas(credit on one cell debit on one cell balance on one cell) Reset password excel 2003 Select last row excel 2003