Three quick ways to compare data in Excel

Do you need to know what has changed between two large datasets in Excel?

Here are three ways to do it in under a minute.

Links:

[PaulineParrish]

Thank you! I was able to extract the info I needed very quickly using this methodology! Thanks for sharing!

[iandollery]

Thank you, that was much simpler than I was considering

[electricia]

This was really useful, and it was very clear and easy to understand. Thank you!

[crohunter]

How do I put both lists side by side and then make both lists equal so I can compare apples to apples on each row? Vlookup?

[gabrielzhou]

Thanks Steve, may I know the quick way to check changed data as the video said in the last? Many Thanks!

[junyo]

Hi, do the two spreadsheet have to have the same number of columns?

[CENTAUR]

What is the comparable way to do this with Power Query?

[mpvincent]

Very helpful! I had an issue that I cannot resolve when getting #Value! message instead of the validation. it is failing on a text field. I tried changing formatting and tried to remove and replace plain txt but it does not resolve. Any ideas?