Dear Chandoo
Please forgive me if the title is not accurate.
I am a fairly basic user of Excel and have just started a role that requires much reporting.
I have an email exclusion list and would like to know the best formula to search current data to exclude the emails from my list.
I have uploaded a basic example of the 2 sheets I wish to compare and return the text "Include" or "Exclude" in another column. As I'm not certain which formulas require sorting of data, it might be better to assume that I cannot sort data. Again please forgive me if there is already a post relating to something similar.
Many thanks for your help,
M
Please forgive me if the title is not accurate.
I am a fairly basic user of Excel and have just started a role that requires much reporting.
I have an email exclusion list and would like to know the best formula to search current data to exclude the emails from my list.
I have uploaded a basic example of the 2 sheets I wish to compare and return the text "Include" or "Exclude" in another column. As I'm not certain which formulas require sorting of data, it might be better to assume that I cannot sort data. Again please forgive me if there is already a post relating to something similar.
Many thanks for your help,
M