Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
Hi I have an excel sheet with two columns
Column 1 - is OLD
Column 2 - is NEW
I would like to compare the NEW email with emails in OLD column, and if it found in OLD data then remove it in New column
Example as this
<tbody>
</tbody>
Thanks in advance
Email formats have been mimicked to avoid privacy issues
Column 1 - is OLD
Column 2 - is NEW
I would like to compare the NEW email with emails in OLD column, and if it found in OLD data then remove it in New column
Example as this
OLD | NEW | Result |
xyz@bbec.com | ||
abc@gmaa.com|cde@dca.com | mam@ma.com|da@da.com|ee@ee.com|cde@dca.com | mam@ma.com|da@da.com|ee@ee.com| |
123@outlk.com | 123@outlk.com | |
<tbody>
</tbody>
Thanks in advance
Email formats have been mimicked to avoid privacy issues