vehloaaron
New Member
- Joined
- Jul 2, 2021
- Messages
- 1
- Office Version
- 365
Hoping someone can assist with a problem I think Excel can solve for. I have duplicate email addresses in a database, if one duplicate opts out, I need to find all matching emails and opt them out to. I think I could use a SumIF statement using a helper column that identifies the email as a duplicate, however I can't quite get it to work as I would like. Below is an example of what I am trying to do, column G - I are desired state.
OptOutTest.csv | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Duplicate | Email Opt Out 1 | Email Opt Out 2 | Email Opt Out 3 | Email Opt Out 1 | Email Opt Out 2 | Email Opt Out 3 | ||||
2 | aaront@duplicate.com | 1 | TRUE | TRUE | TRUE | ||||||
3 | aaront@duplicate.com | 1 | TRUE | TRUE | TRUE | ||||||
4 | aaront@duplicate.com | 1 | TRUE | TRUE | |||||||
5 | Aaront@notaduplicate.com | 0 | TRUE | TRUE | |||||||
OptOutTest |