Current Scenario
While using the dynamic arrays formula in data validation list is not returning the arrays values, we need when enter the dynamic arrays formula in a column then call the arrays using # in data validation

Requested Solution
Allowing user to use the dynamic arrays formula in the data validation directly instead of using the helper column.

I've started using the Stocks data types and now all workbooks that have them get the disclaimer banner on each sheet every time I open it up. After seeing it a few times, the user needs to have a way to turn it off. Otherwise , it just an annoyance. Thank you.

The new UNIQUE(), SORT() and SORTBY() functions are incredibly useful and they save a lot of time. It would be helpful though to allow UNIQUE() to optionally ignore blanks. I use UNIQUE() to build named arrays dynamically which I can use as a validation list for data validation. At the moment I have to create the list (e.g. SORT(UNIQUE(<some column in a table>)) and then created a Name using OFFSET() to ignore the blank at the start of the sorted list.

Certain items, especially income, need splitting; in order to accurately separate expenses like withholding for taxes or healthcare premiums.

If Mac subscribers of Office 365 are getting less features and PC subscribers, prorate the Mac annual subscription accordingly. If not, MAKE BOTH VERSIONS OF EXCEL HAVE THE SAME MENU FEATURES!

I open one particular spreadsheet and a warning comes up that there is a circular calculation but it doesn't tell me where and I can't find it.

I think it would be a good idea to add the page & cell reference to assist the user find the problem

This should be a relatively easy one: In the HYPERLINK function, please add an optional argument for assigning a Screen Tip.

I think of my finances along main domains, like housing, auto, healthcare, etc. Each of the domains, however, should have user-defined subcategories that can drilled down to when needed.

A functions to combine arrays and return a single array. For example, I have a spreadsheet that contains a list of schools and a list of theatres. Some schools also have theatres, so I would like to combine a subset of the schools with the theatres to produce an array of venues that then be used as a validation list. Currently I use the new FILTER() and SORT() functions to create 2 arrays and then use an awkward and complex array function with helper functions (based on MID()) to combine them. Would be great if I could just e.g. SORT(COMBINE(A3#,B3#))

Make a randomizer (for contests, sample data, or simply randomizers) which uses 2 columns; one with the value, one with the weight of said value. Making a randomizer which uses weighted values is a huge pain as of right now!

Make the SUM function more convenient to use so when you click the individual cells it will added them opposed to having to put + btw cells

basic functions for excel

One can search and Scroll in the Formula dialog. If you don't know what excel will call a function you need to scroll. What you usually know is if you will need a function on text, Date/time, number, stats etc... It would then be very nice to filter the enormous list of functions based on topic / data type you are to operate on.

Seems like a small feature add, that would help a lot.

Please add the Let function to macos excel. Some people/colleagues are already using the Let function in the Excel Windows version documents and the file doesn't work on the Mac.

improve the filter function in excel for Mac - make it work the same as with excel for PC