Share via

Comparing two DIFFERENT datasets

Anonymous
2023-11-09T16:04:04+00:00

I’m looking for advice on how to compare two different worksheets for differences, perhaps by the highlighting of differences on one sheet. The issue is that the data set I’m comparing to is in a different format e.g. less columns and was essentially used to build the larger dataset. That’s why they should match and I want to make sure everything is consistent and there are no discrepancies. 

The data itself is not too complicated - there is a date column and shipment data that matches up to it. All the dates and corresponding data should be the same as in the larger dataset. 

Any advice would be appreciated, thanks in advance!

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-10T05:25:32+00:00

    please provide some dummy data.and expected result.

    1 person found this answer helpful.
    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-11-10T08:37:40+00:00

    Use Power Query and the kind of JOIN that fit's to your expected result. See video below and you'll understand what I mean.

    Andreas.

    Merging Data with the 6 Joins in Power Query: Inner Join, Outer Joins and Anti-Joins Exlained - YouTube

    0 comments