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.
- Your description above is more or less exactly what my little tool automates. Shame on your IT dept for blocking content that would have saved you a lot of time I'm sure. Perhaps you can ask them to except my domain from their blocking policy?