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.