Forum Discussion
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...
As variant that could be
=LET(
ra, ROWS(Table1),
rb, ROWS(Table2),
k, SEQUENCE(ra+rb),
SORT( UNIQUE( IF(k<=ra, INDEX(Table1[Column1], k), INDEX(Table2[Column2], k-ra))))
)which returns
Thank you very much for your reply.
And although the what needed is 100% correct but I would really appreciate a formula instead of an array that is dragged down to a certain point and those cells are updated as accordingly.
A formula that engages in a mixture of index and match is especially not control-shift-enter.
I hope you understand.
Thank you again for you help, I really do appreciate it!
And although the what needed is 100% correct but I would really appreciate a formula instead of an array that is dragged down to a certain point and those cells are updated as accordingly.
A formula that engages in a mixture of index and match is especially not control-shift-enter.
I hope you understand.
Thank you again for you help, I really do appreciate it!
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
- Also, after double checking, the master column in sheet3 does not update or correspond whenever I add or amend items.
Again, please, I need a formula.