Finding Unmatched Records

P

PA

Using Excel 2007, I have two worksheets, one has a list of national
membership, including an ID # in column A, the other will contain the similar
information of individual who are attending a national conference. I need to
find those on the membership list who have not registered for the conference.
Thank you
 
E

Eduardo

Hi,
in another column enter

=MATCH(A1,Sheet2!$A$1:$A$30,0)

change sheet2 for the name where you have the members registered to the
conference, where the result is N/A that is a member not registered, you can
sort by N/A to get all the members not registered
 
R

Roger Govier

Hi

Assuming the ID number is in column A on both sheets

=IF(MATCH($A2,Sheet2!$A:$A,0),"Attending","Not Attending")

Change the ranges to suit, and copy down the column as far as required
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
If then formula with multiple cells 2
Problems with count, counta and countifs 6
unmatched query not working 2
CFP: 7th International Workshop on Critical Information Infrastructures Security (CRITIS 2012) 0
CFP: 7th International Workshop on Critical Information Infrastructures Security (CRITIS 2012) 0
MS Project Import Error Row 1 Column 5 2
MS Project Center-Autolink column fields 0

Top