Home

How to Compare two lists and extract the new values in Excel

Mar 12, 2010 11:42 PM

Excel spreadsheet displaying sales data and formulas.

Excel dilettantes and seasoned Microsoft Office Pros alike are sure to delight in this tip, which comes to us by way of the 540th installment of ExcelIsFun's series of Excel magic tricks.

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.

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.