Excel Forum



Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method


See how to check two 2 lists of records and extract only the new records (records that are in new list but not in old list) with array formulas that use SUMPRODUCT, ISNA, MATCH, IF, ROWS, SMALL, INDEX, ROW functions function.
Compare Two 2 Lists





Got a Question? Ask it Here in the Forum.