I need a small advice.
Please look at the attached excel table
I have a table with several columns.
I have to compare e-mail addresses which are in column F with email addresses which are in column D and E
The goal is to make sure an email message was sent to all required people/groups which are in column F. If any email address was not included in original email message then I will have to forward an email message. Firstly I have to identify if anything is missing and if yes then put the email address/addresses in column G
(*Please note in column D and E I have always ‘a’ this is not a mistake and also there are no ‘;’ separators between addresses in column D and E)
BookForum.xlsx (9.2 KB)