Loading...

Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Lists

22,684 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 2, 2008

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

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...