Posts

Showing posts with the label ARRAY

Slice array in Google Sheets

Image
Many functions in Google Sheets return an array as the result. However, I find that there is a lack of built-in support functions in Google Sheets when working with an array. For example, the GOOGLEFINANCE function can return the historical prices of a stock as a table of two columns and the first-row being headers Date and Close. How can I ignore the headers or remove the headers from the results?

If my work has been helpful to you 🙏

Support AllStacksDeveloper blog a coffee if you find the contents useful!