Forum Discussion
Using Exact function
Trying to compare two columns containing email address to weed out those that do not match and create a workbook of valid addresses. How do I do this?
2 Replies
Hello,
can you post a data sample with Before and After, so we can see what you would like to achieve in context? You can attach a file, but please use made-up, dummy email addresses only, not real ones.
Hi Pamela,
There are some formulas, but perhaps in that case easier will be to copy/paste all addresses in one column, select this column and in ribbon Data -> Remove duplicates
