Don't fall into the trap of masking structural errors in your spreadsheet.
Write Excel formulas that are easy to understand and don't consume lots of memory.