Copying a folder name and pasting it in a cell may not be a common operation, but sometimes we do so.
Therefore, it would be great if you could fix the issue that the characters on the formula bar get corrupted in the operation above.
This issue has not been fixed for a long time and is always reproducible.

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.

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

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.

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!

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.

Using Frequency function, you can input a list of classes then compute the occurrencies of data selected as a matrix formula. What about classifying each item in the data interval in the class computed?
Instead of a series of "if data in rangeA; classA; if data in rangeB; classB;0;0...), why not using the same list of classes for a new function CLOOKUP or CASEIF(cell;classMatrix;classNameColumnIndex;<= or <upper range limit).
Examples: Pareto analisys, ABC, Inventory Cross analisys, Data stratification

1. We need a simple function that can tell us the last date a change was made to a cell.




2. We need a "find all" function that lists all examples in a separate box, together.

Find all isn't available on Mac. Online and PC have this function. Needs to be on Mac too.

as in Windows version of Excel, unable ability to define scope for a named range so that a named range can be used across all opened worksheets

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.

Need a shortcut to trace precedents and dependents

Il semble que cet ActiveX de contrôle soit disponible pour Excel dans les PC Windows. J'aimerais svp cette fonctionnalité disponible dans le mac. Je deteste faire qq travail dans les windows.

データの入力規則で、「リスト」を選んだときに「元の値」の欄で、あらかじめ定義ずみのセル範囲の名前を F3 キーで呼び出せるようにしてほしい。Windows版エクセルではできるので。

Please include the ENCODEURL function in the Mac version of Excel. I don't want to keep having to ask coworkers to update my spreadsheets.

Why are all of the newer functions not ported to Mac?

Currently, IRR and NPV functions in EXCEL calculate present values by discounting initial number in the series.

It would be useful to provide option (or default setting) by which IRR and NPV are calculated without discounting data in the initial year (initial year is current year, so no discount is necessary).

If model requires discounting in the initial year, formulas could still be used by adding 0 to the beginning of data series.

Currently in this scenario both NPV and IRR has to be calculated manually, and formulas cannot be used.

Under "Conditional Formatting", have "=MOD(Row(),2)=1" as a preset.

Amazing for dyslexics/visually impaired

Not just simply copy and paste but shortcuts to the tool bar.