Excel Magic Trick 1111

Item In Both Lists? Extract With Better Array Formula

DESCRIPTION

See how to extract items in List 2 that are also in List 1 using a great array formula from Exceli Adam at YouTube that uses the functions IF, INDEX, MATCH and AGGREGATE.

MATCH contains a function argument array operation that creates a resultant array of items that AGGREGATE can handle without having to use Ctrl + Shift + Enter.

WORKBOOKS

Download “Excel Magic Trick 1101-1120” Excel-Magic-Trick-1101-1120.zip – Downloaded 86 times – 2 MB




Be the first to comment

Leave a Reply