Forum Discussion
major_johnson
Aug 28, 2021Copper Contributor
Compare Two Columns in Two Sheets to Remove Duplicates and Return One Copy Only
Good Day, Friends! I have one column in sheet1 and the other in sheet2. Columns have duplicates, within itself as a column, as well as when both columns are compared to each other. I would li...
SergeiBaklan
Aug 28, 2021MVP
That is not CSE formula, that is regular formula which returns the spill automatically updated if you add new data into structured tables (Table1 and Table2). If I add some data into Table1
and same into Table2
resulting spill will be
major_johnson
Aug 28, 2021Copper Contributor
- SergeiBaklanAug 28, 2021MVP
- major_johnsonAug 28, 2021Copper ContributorOh, I am sorry, I am using MS Pro. Plus 2010. 😞