Help & Support
Send Feedback
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
No users
Works with
Install
Overview
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
No comments
Additional information
Search
Clear search
Close search
Google apps
Main menu