Add a dynamic array function to split apart a delimited range. See attached file for an example.

Create new functions that SUM each column in a dynamic array (SUMCOLS(Ref#)) to produce a row of totals, and SUM each row to produce a column of totals (SUMROWS(Ref#))

Also COUNTCOLS, COUNTROWS, AVERAGECOLS, AVERAGEROWS, but these are less important than SUMCOLS & SUMROWS.

The new Dynamic Array function UNIQUE is awesome. It can return all of the unique items in a column or in a row. But it would be nice if the second argument could accept a 3 to indicate cell-by-cell.
For example, see the screenshot below.

Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!

One of my least favorite messages that Excel provides is:

"Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."

But I can never find the bad references. It's usually buried somewhere very deep, in a chart series formula, or in a name definition, or who knows where else.

If Excel finds a problem, please Excel, tell us where it is.

I'm proposing that header argument be added to the FILTER and UNIQUE Dynamic Array Functions just like we have seen in the STOCKHISTORY function

Corkscrew accounting is fundamental to Financial Modeling. It is where opening balances are carried over from closing balance of prior periods..

=OpeningBalance(FirstPeriodBalance, PriorBalances)

Where FirstPeriodBalance is the first period's opening balance and PriorBalances is an array of closing balances for each period.

The cell containing this function will return FirstPeriodBalance. The SPILL range will contain the n-1 closing balance array value.

https://corporatefinanceinstitute.com/resources/excel/study/corkscrew-calculation/

Create a function called ArrayJoin() or ArrayConcat(), this would join two or more arrays together to make one array. This could be used on spreadsheet directly or embedded in inputs of other functions eg to dynamically organise inputs for MMULT().

I don't know of a way to use the cell color as a reference point in a formula, i.e. =IF(A2=Color X,(B2/C2),D2) I would like this capability.

Currently XLOOKUP can return an array of return values, given an array of search values, OR a range corresponding to a single search value. Like other functions, it does not return an array of ranges but, rather, truncates the calculation.

This may have been acceptable in the past when the expectation was to copy formulas across to return values that logically form an array. As dynamic arrays receive increasing use, the expectation will change and the failure of a range to spill will be far more problematic.

Add a CHOOSECELL function. It should look like this: CHOOSECELL(columnletter,rownumber) and it will give you the cell you chose.

Unable to create the sub-categories under Category in Money in excel application.

With increasing use of dynamic arrays for time series data such as stock prices we need a way of doing moving averages with dynamic arrays.
I suggest something like

MOVAVG (RangeArray, N, MAMethod [, Down] [,StartExp])

where N is the number of periods in the moving average and MA-Method controls the MA calculation method method (Simple, Central, Cumulative, Weighted, Exponential, Double Exponential etc)

I would like to be able to have a formula where in a formula can be build with operators in another cell. As an example where =formula(a1&b1&c1) where the cells would have 1 + 1. in other words b1 would have a + in it. This will make it possible to change operator in a large amount of formulas with only changing input in one cell.

Hi. You could create a new option 0 as the sort_order argument of the SORT function. Today we have 1 for Ascending, -1 for Descending and then we would have 0 representing shuffle, random order.

In addition to an ACCUMULATE function to enable cumulative sums and corkscrew calculations we also nee a DIFF function to calculate differences between values in a dynamic array.
Something like
DIFF (Range_Array [,StartValue] [,Lag] [,Order] [,Align] [,Down] )