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...
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?