Quote Originally Posted by amit.wilson View Post
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