DESCRIPTION

See how to compare two e-mail lists where one list has extra semi-colons and we want a dynamic formula that can handle periodic data dumps.
(00:08) Setup of problem
(00:46) Excel Table Feature to create dynamic range.
(01:42) Is in List: MATCH, ISNUMBER and SUBSTITUTE functions, Table Formula Nomenclature (Structured Table References), non-array formula.
(03:37) Is in List: MATCH, ISNUMBER and SUBSTITUTE functions, Table Formula Nomenclature (Structured Table References), Yes: ARRAY FORMULA.
(05:59) Test the new data dump: Contract and Expand Excel Table using Mouse.

WORKBOOKS

Download “Excel Magic Trick 1091-1100” Excel-Magic-Trick-1091-1100.zip – Downloaded 23 times – 194 KB