How to compare 2 Lists in Excel and extract records using a array Formula.
There are several ways to compare two Excel lists. The VLOOKUP Function is probably the most used by most excel users. This video that I'v found at YouTube.com , shows how you can use an array formula to compare two Excel list and extract either the items that are in both list or the items that are only in one of the list.
It's a very interesting technique that can be quite useful for medium/advanced excel users.
No comments:
Post a Comment