Matching duplicate records from different excel CSV files

Hello,

I've been trying to match records from two different CSV files and deleting the ones which do not match.

Here's the exact question:

The Membership.csv file contains details of people who are no longer members.
The Attendances.csv file is the up-to-date list.
The manager wants you to find out which members should no longer be included in the
membership list.

How can I solve this problem? Please help

Thanks

Originally Posted by amit.wilson

Hello J - welcome to the forum.

In the membership file, setup a column to do a vlookup on the data in the attendance data. If there is a match, put the result as 1 else 0. Sort the membership data on this vlookup column. Then delete the all the rows with 1s.

Cheers

Thanks a lot for your reply..

I tried doing a vlookup, but I didn't really get it. I'll appreciate if you could elaborate a little more (I'm new to this stuff).

I think my question wasn't clear enough. Here's a better version:

There are two tables; membership.csv and attendances.csv.
The membership.csv file contains members who are both inactive and active. The attendances.csv file contains only active members.
So the question requires us to find out which members should no longer be included in the membership.csv file and delete their records.
How can I do that?

I hope this explains it well.

Thank you once again for your help.. waiting for your reply

Originally Posted by FDibbins

This sounds very much like a homework question?

Not really, I'm doing a CIE practice paper for my examinations