Which Similar Array Formula? Compare Number of Array Operations
Learn how to build similar formulas and compare the number of array operations in order to decide which formula might be most efficient:
(00:08) Problem set up and look back to Excel Magic Trick 1222
(01:38) SUMPRODUCT and SUBSTITUTE formula with 2 array operations
(03:15) SUMPRODUCT and LEFT and LEN formula with 4 array operations
(04:39) SUMPRODUCT and LEFT and SEARCH formula with 4 array operations
(05:27) Formula Evaluator to watch how the Array Operations Calculate
(07:04) Time Formula with VBA code from Excel MVP Charles Williams
Which Array Formula To Use?
Reference video: Excel Magic Trick 1222: Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format?