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.

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!

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.

Please provide Alt key equivalent shortcuts for the Mac

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.

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

Include it please ini Excel for Mac

I would like to be able to use a formula to match partial text from a column using an if statement as criteria to enter text from a column heading in another column. I have a sample file attached. You can see that I have entered the text in the columns I want. I use a filter and search to do this, but it takes a long time and is very repetitive.

This function would be highly improved if it could compute even lower intervals (hourly, etc.) as stock prices can change significantly throughout the day. The start/end date arguments could change to start/end time and the intervals argument could include hourly. I'm not sure how stable adding even smaller intervals (minutes, seconds) would be as that would result in extremely large arrays. Thanks for considering!

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.

I´m working with macros in excel for Mac, but when I go to the insert tab in order to add an userForm that option doesn´t appear. Please bring it back. Or theres another way to do this process?

Bonjour, j'utilise Excel sur PC iMac.
J'ai un problème, je souhaite utiliser la syntaxe DATEDIF, mais cette dernière n'apparait pas dans la bibliothèque des formules et lorsque je la rédige elle ne fonctionne pas.
J'ai été en relation avec un conseiller via LogMeRescue, qui n'est pas parvenu à résoudre mon problème.
Merci de bien vouloir m'apporter une solution.

Example: for an PT-BR version of Excel, I want to input EN-US formulas.

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.

Put back subtext when building formulas. The text that lets you know where you are in the formula.
Examples from previous editions: "argument", "value if true", "value if false"...

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