Cleaning Excel Sheet

详细信息

1) Clean active members spreadsheet.- I have an excel spreadsheet of 200 'active' members, and I need someone to clean this list so that it only includes paid members. - There is one column called 'Active memberships'. Keep rows that have data in 'active memberships', and delete rows that do not have any data in 'active memberships'.
2) Clean 'email subscribers' spreadsheet- I have another excel spreadsheet of email subscribers, and I need this to be cleaned so that it only includes people not paying for memberships. - This would involve taking the newly cleaned 'active members' spreadsheet above and removing these members from the 'email subscribers' spreadsheet
3) Final clean of 'email subscribers' spreadsheet- 5 days before the email campaign, remove another list of people from the 'email subscribers' spreadsheet- This will be around 10-20 people on another spreadsheet, who are new enquiries who have not yet attended a free session, so do not need to receive the email campaign
I've attached the first two spreadsheets, and I will send the final spreadsheet on the appropriate date (27th May)
I look forward to hearing from you!