Excel Forum
Similar Content
Easily Compare Duplicate Values in Excel
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Simple Excel Function to Extract a Word or Text from a Cell
Tutorial: Excel function that makes it easy to extract a word or text from a cell in Excel. This is ...
Filter Data in Excel to Display Records that Contain a Value Between Two Values - AutoFilter.
Macro: This free Excel macro filters data to display only those records or rows that contain a va...

Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice

See array formula that will extract records that are not listed twice. See the functions: ISNA, MATCH, SUMPRODUCT, IF, ROWS, SMALL, ROW.

Got a Question? Ask it Here in the Forum.