compare excel tables

in Excel

Compare Excel tables using Consolidate


Ever needed to compare tables in Excel. Hope you never did it row by row. 🙂

If you know a few things about Excel, you probably know hot to compare tables using VLOOKUP. You need 2 of them actually and then with a filter, you can get the job done.

Comparing using Consolidate

This method is however faster than VLOOKUP, and easier also. You just select the 2 tables and let Excel do the rest. The whole process takes less than one minute, you don’t even need to know what VLOOKUP is.



See bellow:

Other ideas

Got any other ideas, let me know in the comments bellow.


Was this article helpful?

Follow me on Facebook