asked

I need a spreadsheet where I can drop any data into the 'master source list' and have the info processed in all other sheets and columns automatically. The key requirements are: (a) split the emails by segments; (b) look for duplicates of the same email elsewhere in the master source list - if duplicate, eliminate; (c) eliminate any emails which have one of the words listed in column B - need 5,000 cells in column B with words; (d) eliminate all emails which are strings of numbers such as '[email protected]'; (e) split the validated emails into different segments based on their structure (before and after the '@' sign, between periods, etc.). Can you create a single sheet that processes all these tasks automatically when new data is dropped into the 'master source list'?

March 16th, 2023

Sign Up to View Answers

Create an account to view answers and interact with the community!