It would be great if Excel for Mac (Insiders) is able to have the new Stocks functionality currently used by Excel for PC (Insiders)

This functonality is described in https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

In respect of this particular capability, it would bring Excel for Mac more in line with Apple Numbers which currently offers something similar.

Thank you for considering this addition.

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.

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.

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?

Blinking briefly or highlighting matching/ pared parentheses when checking through or writing a formula in the formula bar for Mac. Like it does on windows.

SUMPRODUCT should calculate a value from the same dimension-size arrays regardless of their vertical or horizontal alignment like for example =SUMPRODUCT(A1:D1,F1:F4)

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.

We have the transpose function that allows us to swap data from rows to columns, or vice versa … how about a function that allows us to swap data between two different rows, or two different columns. For example, if I have data in A1:A10 and I have data in B1:B10, I could highlight both sets of data, and by choosing this new function, I could swap the data, whereas A becomes B and B becomes A.

Can the weight of the grid lines be chance? the weight of the grid lines make them lighter than the input in the cells

Merci de me dire quand user forms pour mac urgent
cordialement

Please put the function for addition back on Excel - the one where you hit "=", then highlight the column of numbers, then hit "=" again and it adds up for you. It is way more efficient than what you have now.

Please inser function chek cella in Excel for Mac

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.

dosyada fatura kımında ki rakamlar görüntülenemiyor

If a user has a spreadsheet that has calculations set to "Manual" (for what reason, I can't fathom), if they open that spreadsheet *first*, then all subsequent spreadsheets open in that session will do manual calculation.

Calculation settings should not be *global* like that. If you have to have a Manual calculation spreadsheet, that should only affect *that single spreadsheet* -- not any others that may be concurrently opened.

This is a terrible design choice.

It would be great to have the ability to use a function that targets a cell and when the target cell receives a value gives a "static" Date and Time stamp. Also have a true/false option for updating timestamp when target cell value changes.

Currently the only options are VBA or circular reference. NOW just isn't any use for static timestamps?? Or have

In older versions, (2011) when you entered "=" and clicked on a particular cell, it added that cell's value to the formula. You could then click on another cell and it would use addition to add the second selection. Example: When entering = and clicking A1 then clicking B1, then clicking C1, formula would calculate "=A1+B1+C1". Now we have to manually enter "+", or the cell first clicked is replaced with the most recently selected cell.