Log In
Register
Home
New Member
July 22, 2020
Offline
Hi
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
red y
white y
potatoes
this can get updated and be returned like this
10 20 50 60 80
sugar y y
red y y
white y
potatoes
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.
Regards
VIP
Trusted Members
December 7, 2016
Offline
Hello,
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.
Br,
Anders
August 21, 2019
Offline
Hi Silver,
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.
1 Guest(s)
