July 22, 2020
I am trying to find a method of highlighting differences between different updates to excel docs.
Essentially the doc appears something similar to this:
10 20 40 50 60 80
sugar y y
this can get updated and be returned like this
10 20 50 60 80
sugar y y
red y y
some columns might disappear and new Y put in - is there a quick way of highlighting the changes - FWIW not working off a network shared doc.
December 7, 2016
Have you tried the tip from this blog post? It shows how you can use Power Query to compare two lists. The example in the blog post is of course simplified, but the method is the same.
August 21, 2019
first you need to unpivot the two cross-table in Power Query Editor, then Merge to compare the same items/Attributes, and the different items/Attributes
Once you develop this query in PQ, any amendment to the source table 1 and table 2, just goto the result, right-click and refresh for the updating comparison results will do.
you can download the blog example recommended by Anders and go through it, not difficult and quite cool, thanks Mynda for her wonderful tips.