By
Today's quick blog article will talk about a favorite formula string I use time and time again. If you read my blog, you know I use Excel as my tool of choice for data manipulation.
My challenge today was to find and match emails in two columns. What I wanted to do was weed out emails that were duplicated in both columns. I used a formula and will explain it below.
Let's use the following list as my example:
Column A
Column B
Column C
This email address is being protected from spambots. You need JavaScript enabled to view it.