Matching duplicate records from different excel CSV files

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