I know, I know...Mac Users are different, but it doesn't mean they can't benefit from clear insights to their Formulas.

Alt+T, U, F in Excel for Windows gives a step-through window for evaluating a given formula. This isn't an option on Excel for Mac. Is there any work being done to enable it? Just wondering also why such basic functions for maintaining workbooks wouldn't be available across platforms.

Looking forward to hearing back.

Thanks.

BPC.

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

Why after so many years of people requesting that Find All button be added to the Find dialog box in Mac Excel version it's still not there? How difficult is it just to add a button?

Can there please be the ability to drag the below function down the column and the sheet number changes automatically only. The '$' sign fixes the cell but I need the ability for the sheet number to change automatically in numerical order as I have over 200 rows and 25 columns to change manually!!

='18'!$B$3

A function to populate another cell. Something like;

IF(a1<>0,LET a5=a1,LETa5="") as a function in any cell other than a1 or a5

This populates a5 if the condition is met but enables a value to be typed into a5 without overwriting a formula.

As far as I know, this can only be done today with VBA. This would be so useful to me.

The UserForm command is not available in Office 365 (Excel). I need it!!
Especially as user interface to fill in data in large Excelsheets.

Its completely useless and just frustrating.

To insert a time or a date, we can either use the stamp function (e.g. ctrl+;) or use the formula (=TODAY). I would like to have the use of a timestamp inside a template, so that when we create a new sheet from that template, the fixed date appears, i.e. as a datestamp. I haven't found how to do this using help.

We can use '=SUMPRODUCT( (MONTH(A1:A10)=MONTH(TODAY()) )* (B1:B10) )' to get a result from dates.

However
'=SUMPRODUCT( (WEEKNUM(A1:A10)=WEEKNUM(TODAY()) )* (B1:B10) )
does not, because WEEKNUM can't handle an array or range.

Please give us a WEEKNUM that handles Array and ranges

Thank you.

As a student, I have purchased a lifetime license for Microsoft products. It seems ridiculous that I am barred from using functions such as "MAXif". Why can't all functions be made available? I am sure NO company will get rich making extra $ from students in this manner. This is so sad.

In Office 2011 for Mac in the pulldown File menu the user had the option to Clear Recent. This option is missing in Office 2016. It was a useful feature. You should put it back.

DON'T MAKE A CHANGE THAT PUTS MORE "STUFF" DO DO IN WHAT USED TO BE A VERY SIMPLE AND RELIABLE METHOD. WHY ON EARTH WOULD YOU MAKE A VERY SIMPLE SYSTEM THAT WORKED SO MUCH MORE CUMBERSOME?

windowsでは正しく反映されるが、マックでは反映されずストレスを感じる。

Current Issue just discovered talking to MS Excel Support to see if there is a work around or if someone is solving this error.

Issue is that when you place values in a cell and do a =ROUND function to format a currency value it rounds down not up. i.e. Summing to Cells and trying to find tax for the two values return in correct value.
=ROUND ($33.165, 2), returns 33.16 and not 33.17. This is a major show stopper for financial calculations and worksheets.

I’d like to see a “parse” function that can easily separate out strings in cells and pull just one element instead of doing multiple mid() and find() functions. e.g. =PARSE(“Gift card from Company for $200”,4) would return “Company” or ,6 would return $200 etc. Maybe an optional parameter to specify the separators (sometimes it’s hyphens, sometimes spaces, sometimes bars etc). Another optional would be how many words to pull starting at word x, e.g. =PARSE(“This has useful data about product”,3,2) would return “useful data”

Formulas can get extremely messy with messy data. This is especially true when a formula is 10+ lines long. Often, re-reading a formula a few weeks later is absolutely indecipherable. Can we somehow be able to add notes to a formula, similiar to the ' in VBA?

Please make same function excel for mac and window users so that we could be easy to use and command or shortcut key also be same.

Where has the Name Manager for Mac (Excel 2016) gone? I have imported work done earlier on a Windows platform and now need to work with the named ranges...but cannot find a way to access the Name Manager. The suggestion I find on the web to push command +fn + F3 does not work.