This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 86%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
I upgraded from Office Home 2019 to Office Home 2024 in order to use ARRAY functions on excel to enhance performance for a google sheet we are using. Unfortunately, there seem to be NO ARRAY functions in this product. I researched this using ChatGPT and Perplexity before upgrading and they said it SHOULD have the functions. I do NOT want a subscription plan, only a paid product.
What am I missing?
What are my next options?
Tis is an excerpt from Excel Help:
Beginning with the September 2018 update for Microsoft 365, any formula that can return multiple results will automatically spill them either down, or across into neighboring cells. This change in behavior is also accompanied by several new dynamic array functions.
For more information go to Help> Excel Help in the Excel menu bar & enter array as the search criteria.
