Excel Magic Trick 1099

Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range

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 1082 - 1100” Excel-Magic-Trick-1082-1100.zip – Downloaded 97 times – 2 MB




Be the first to comment

Leave a Reply