Hello everyone, I’ve got two excel tables, I need to start with first cell of table1 and compare with every cell in table2, and loop it to the end of table1 and write all cells which does not exist in table2 in new column for example.
Sorry if its not new request, but i saw only row compare, not each cell with each cells.
Two random tables in attachments.
Thanks for help.
I guess the best & the efficient solution for you is Datatable Joins…
here, they mention a join type called “Left Join”. In this method, the join will produce nulls for all the records that do not match to any record in table 2. That’s the set of records you are looking for