Forum

Notifications
Clear all

Compare two excel docs and highlight differences

3 Posts
3 Users
0 Reactions
82 Views
(@silver)
Posts: 1
New Member
Topic starter
 

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

 
Posted : 23/07/2020 8:37 am
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

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

 
Posted : 23/07/2020 11:39 am
(@bluesky63)
Posts: 162
Estimable Member
 

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.

 
Posted : 24/07/2020 9:09 am
Share: