Forum Discussion
Comparing Similar tables in excel - Power Query?
I want to take two similar but not the same tables, compare them, and generate 3 to four spreadsheets that can quickly and concisely identify the differences between the two tables - finer details re...
Have a look whather this tool helps: https://jkp-ads.com/Download.asp#Compare2Tables
JKPieterse Thank you for the link, I could not open it due to some policy settings regarding downloading macros without determining it was safe or something - work computer.
I did manage to learn a way to do this, I posted a reply detailing how I did it with Power Query. It is good to know how to do it yourself so you can customize which columns are relevant for your comparisons too I think, thanks again for the link though. Much appreciated.