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 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).
Riny_van_Eekelen I have a 365 subscription, and your example works correctly in my Excel version.
Now I just have to understand FILTER semantics a little better :-). Thanks so much!!
Now I just have to understand FILTER semantics a little better :-). Thanks so much!!