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.