Forum Discussion
Pamela Wright
Aug 29, 2017Copper Contributor
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?
SergeiBaklan
Aug 29, 2017MVP
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