New Text and Array Functions for Excel
techcommunity.microsoft.com
New Text and Array Functions for Excel
1–10 of 55 posts
Re: New Text and Array Functions for Excel
#2I am very surprised they have not yet embraced the dplyr/tidyr-style melt/cast gather/spread pivot/unpivot functions for arrays
Re: New Text and Array Functions for Excel
#3I'm surprised it's 2022 and they haven't embraced a multiline equation editor.
Re: New Text and Array Functions for Excel
#4All these new text functions and still no support for regex? Google Sheets has had regex support for years.
Re: New Text and Array Functions for Excel
#5It’s 2022 and how come they don’t have GPT4 and some stable diffusion built in?
Re: New Text and Array Functions for Excel
#6I'm surprised it's 2022 and they haven't embraced a multiline equation editor.
There is a microsoft garage project that helps you do it that way:
https://www.microsoft.com/en-us/garage/profiles/advanced-for...
Re: New Text and Array Functions for Excel
#7Next challenge: make the find/replace dialog better than the confusing tabbed mess it is today. And make it non-modal for simple search/replace.
Re: New Text and Array Functions for Excel
#8Array functions feel like they're just too far from the excel design thinking. A single function that affects nearby cells is hard for me to swallow.
I kind of wish they went for the matlab cell array style where a function can return an array, but it just becomes a data structured stored within a single cell.
So TEXTSPLIT (which is great, finally), would return an object like ARRAY("I", "SAW","A","CAT") and if you wanted to unpack it you could drag a formula that was something like =$A$1?0, =$A$1?1, =$A$1?2, etc.
Or maybe just one single black magic affects-nearby-cells function called "UNPACK"
Re: New Text and Array Functions for Excel
#920 years overdue...
Another one that is massively overdue: take multiple arrays as arguments and return the distinct values, sorted (kind of like the remove duplicate button, but that doesn't require to click a button). [edit] actually it was introduced in 2021 ("UNIQUE" function)
Also take multiple arrays and returns the values that are in common (like an inner join). Use case: you want to align two time series by creating a 3rd time series made of the dates common to both original time series.
Then you can have all sort of finance related function. Validate the checksum for an ISIN, CUSIP, SEDOL, etc.
Excel should also come with the most common holiday list (all the major cities at least).
Re: New Text and Array Functions for Excel
#10It’s 2022 and how come they don’t have GPT4 and some stable diffusion built in?
seriously though, I think a copilot-like ML to improve flash fill is a genuinely amazing idea which could save insane hours, especially with people less familiar with complex formulas/coding