Excel Forum



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





Got a Question? Ask it Here in the Forum.