Excel Magic Trick 1111

Item In Both Lists? Extract With Better Array Formula


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.


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

Be the first to comment

Leave a Reply