Excel Forum



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.