Video 00088 Proper Design = easy formula @MySpreadsheetLab
Video 00088 Proper Design = easy formula  @MySpreadsheetLab
Uploaded April 2014 | Updated November 2026, 3 hours ago
The required complexity of formulas often depends on the design of the Excel model.
If a model is designed well then simple formulas - pivots may be enough.
However, if the design is awkward then heavier formulas are required.
This video shows you an example of an awkward data layout, how it should be changed (if time permits) and a solution to get the required answers if there is no time to change the layout.
Video 00088 Proper Design = easy formula00147 Conditionally Add Checkboxes using VBAVideo 00128 Tax LookupVideo 00064 Customized and Sorted Data Validation List_Step 1Video 00033 Solution_identify rows if any in same group meet condition_V200176 Normalize & Pivot Taco Orders00182 Partial Match POWER QUERYVideo 00110 Low Tech Dynamic List00156 One complex formula or Helper formulasVideo 00044 Array Formulas_Example2_EXACT LEFT_functionsVideo 00038 Sample Solution_Top 2 for all testsVideo 00039 Rank Visible Data Only
Kevin Lehrbass |

Video 00088 Proper Design = easy formula

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER