Excel Forum

Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method

See how to use the MATCH function, the Join Symbol (& Ampersand), and the Filter feature to check two 2 lists of records and extract only the new records (records that are in new list but not in old list).
Compare Two 2 Lists

Got a Question? Ask it Here in the Forum.