Hi Guys,
I came across a some excel challenge were I need to remove Invalid emails from sheet1 of sheet2.
I have attached the sample excel sheet.
My Job is to maintain valid vendors list. So, daily I receive hundreds of new valid emails and need to remove invalid emails(I will manually collect invalid emails based on bounce emails)
Challenge is to remove emails from Google Spreadsheet where we cannot run VBA macros nor I do not know how to.
So, I need excel formula to remove Invalid emails.
https://drive.google.com/file/d/0B65hREJXscJUSWo2T3k1MGtJa3c/view?usp=sharing
I came across a some excel challenge were I need to remove Invalid emails from sheet1 of sheet2.
I have attached the sample excel sheet.
My Job is to maintain valid vendors list. So, daily I receive hundreds of new valid emails and need to remove invalid emails(I will manually collect invalid emails based on bounce emails)
Challenge is to remove emails from Google Spreadsheet where we cannot run VBA macros nor I do not know how to.
So, I need excel formula to remove Invalid emails.
https://drive.google.com/file/d/0B65hREJXscJUSWo2T3k1MGtJa3c/view?usp=sharing
