|
Featured Tutorial
Featured Macro
Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Lists
This formula will check two tables and find the values that do not match and then create a new list. Create a unique list of values when two lists are different using an array formula.
See the functions: INDEX, MATCH, IF, ISNA, ROW, ROWS, SMALL, SUMPRODUCT, ISNUMBER.
Also see: Excel Magic Trick #117: Reverse 2-Way Lookup
See the functions: INDEX, MATCH, IF, ISNA, ROW, ROWS, SMALL, SUMPRODUCT, ISNUMBER.
Also see: Excel Magic Trick #117: Reverse 2-Way Lookup