App Icon
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
Works with:
92
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
Additional information
SupportNot available
Privacy policy
Terms of service
STORERANGE() Store any range in one single cell will ask for the permissions shown below. Learn more
STORERANGE() Store any range in one single cell will need access to your Google account
This will allow STORERANGE() Store any range in one single cell to :
View and manage spreadsheets that this application has been installed in
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
No comments
Search
Clear search
Close search
Google apps
Main menu