If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Finding Unmatched Records
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 |
#2
|
|||
|
|||
Finding Unmatched Records
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 "PA" wrote: 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 |
#3
|
|||
|
|||
Finding Unmatched Records
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 -- Regards Roger Govier PA wrote: 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 |
Thread Tools | |
Display Modes | |
|
|