Look Who it Was Random video

Excel Magic Trick 1224: Which Similar Array Formula? Compare Number of Array Operations

2,890 views · Published 12 August 2015 · 8:57 · Indexed 10 November 2026

Channel: excelisfun · 2015 · Education

Watch on YouTube

Download Excel Start File: https://excelisfun.net/files/EMT1224.xlsm

Download File: https://excelisfun.net/
Learn how to build similar formulas and compare the number of array operations in order to decide which formula might be most efficient:
1. (00:08) Problem set up and look back to Excel Magic Trick 1222
2. (01:38) SUMPRODUCT and SUBSTITUTE formula with 2 array operations
3. (03:15) SUMPRODUCT and LEFT and LEN formula with 4 array operations
4. (04:39) SUMPRODUCT and LEFT and SEARCH formula with 4 array operations
5. (05:27) Formula Evaluator to watch how the Array Operations Calculate
6. (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?

More from this channel