Three quick ways to compare data in Excel

[@PaulineParrish]

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

[@iandollery1230]

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!

[@RockstarExcel]

Thanks! Happy to help.

[@crohunter100]

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?

[@adamlasry5225]

Thank you.

[@satishgopal2406]

Thank you 🙏

[@gabrielzhou]

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

[@junyo44]

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

[@cr1994yellow]

Did you get a response?

[@CENTAUR559]

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

[@mpvincent7]

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?

[@masonwilliams1810]

Same issue here

[@Daddythecook]

🎉❤