Excel Magic Trick 1111

Item In Both Lists? Extract With Better Array Formula

TOPICS IN THIS VIDEO

  • 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.