Mention the INDIRECT function in an Excel forum and you'll start a fight. It's volatile, meaning it's always awake and recalculating, which can turn a fast spreadsheet into a sluggish mess. But used ...
They may look harmless, but they're certainly capable of turning your spreadsheets into traffic jams.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results