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