Hello, I have looked on the forum but cannot solve this problem. I have two very large data sets I need to compare in an efficient way. My plan is to create two data tables DT1 (original data ) and DT2 (results data ). These will be formatted the same way and basically I want to log the entire row if one of the cells does not match (create DT 3).
I have seen a few solutions that match based on a cell value but I need to match the entire rows (they will have the data in the same places and should match ). I will upload an example excel shortly. The reason I mentioned filtering by the entire row is because there are 26k rows and over 50 columns with unique data.
I know how to get the DTs up and just need help with the filtering portion.