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.
Got any other ideas, let me know in the comments bellow.