Hello, I’m trying to search two tables that have about 12989 records on them and that are supposed to have the same data on each other, but what seams to happen is that some people only update one table and not the other. I have entered both tables into individual column in excel column A and column B I have tried conditional formatting, but it only highlights the data that is not in the other side, but I still have to search through it and pull out the non duplicates is there a way to compare these two columns and have the data inserted into it’s own column?
The data that I am comparing is alphanumeric and looks like this (ABCC CS 4698 T/C)
