STORERANGE() Store any range in one single cell
In many cases you might need to store an array somewhere with no need to display it.
Use STORERANGE() and keep any array into one single cell.
STORERANGE() stores a range in a single cell so you can use the values without displaying it.
The stored range can be retrieved anywhere in the spreadsheet by using the STORERANGE_GET() formula.
It's like if data would be concentrated and hidden in a unique cell
Use it to:
- Store data without having a need to display it
- Do intermediary calculations
- Keep your spreadsheet clearer