Forum Discussion
Solved
Smart consolidation of 2 email lists? Help requested...
I have two large email lists to consolidate. Each is in an Excel worksheet on a Mac. Some email addresses are duplicated across both lists, and some are on only one list. I'll simplify this to ma...
Dave_Reiner You didn't mention the Excel version you work with so I'm hoping it's ms365 or 2021. If not, kindly ignore this.
The attached file contains a possible solution using the UNIQUE and FILTER functions. Append both lists into one and create a structured table from it (Ctrl-T). Add a column that designates the source (List 1 or List 2).
Dave_Reiner Try the attached. It concatenates both states.
Dave_Reiner It's getting less elegant for every exception, but I beehive the attached version works as you want it.
- Riny_van_Eekelen Thank you - that works great! I still see occasional SPILL errors, but they point me to conflicts in the input data that I am able to fix in the structured table.