NoDataNoBusiness
•  5
Overview
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
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
Reviews
Language:
Sort by:
No comments
Additional information
NoDataNoBusiness
Terms of Service
Search
Clear search
Close search
Google apps
Main menu