- Joined
- Mar 25, 2019
- Messages
- 52
- Likes
- 61
- Degree
- 0
I have 2 email lists:
2000 people who opted in after changing GDPR settings. They are now subscribed to a newsletter.
11000 people who opted in before GDPR, which was also mixed with the 2000 GDPR approved users.
Does anyone know of a simple (Google Sheets?) way to "subtract" the 2000 GDPR approved users from the 11000 person list?
I want to email the 9000 remaining people saying "if you want to opt back in, do x y and z", but don't want to fk up and confuse my 2000 good subscribers.
You can do a vlookup formula on the table of 11k emails to check if they are in the table of 2k emails