STORERANGE() creates a reference of a range in a cell. The range stored can be retrieved anywhere in the spreadsheet by using the STORERANGE_GET() formula.

Use it to:

  • store data without having the need to display it
  • to do intermediary calculations

Install this add-on for Free from the G Suite Marketplace