Excel for Mac
Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a thirdparty service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

Changes to VLOOKUP/HLOOKUP
I suggest 2 changes in Vlookup/Hlookup:
A. VLOOKUP/HLOOKUP functions user can only search for the lookup value in the first column/row, and the result column/row is always after (right/bleow) the lookup column/row.
I suggest to make it more flexible by letting the user decide which column to search in and which columns to retrieve the value from.B. Sometimes user need to drag lookup function to several columns and needs the column index to be incremented, for example to be 3 in the first column, the second column to be 4 and so on, I suggest to add new parameter…
19 votes 
Data Validation to hold New dynamic Arrays function in Validation list
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 validationRequested Solution
Allowing user to use the dynamic arrays formula in the data validation directly instead of using the helper column.11 votes 
Need a way to turn off a recurring disclaimer after it presents itself a few times
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.
4 votes 
Have UNIQUE() optionally ignore blanks
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.
8 votes 
Money for ExcelAllow the same transaction to be split into various catgeories.
Certain items, especially income, need splitting; in order to accurately separate expenses like withholding for taxes or healthcare premiums.
2 votes 
Make Microsoft Excel for Mac EXACTLY THE SAME as Microsoft Excel for PC.
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!
2 votes 
HYPERLINK function  optional Screen Tip argument
This should be a relatively easy one: In the HYPERLINK function, please add an optional argument for assigning a Screen Tip.
1 vote 
Money for ExcelAllow userdefiined subcatgeories
I think of my finances along main domains, like housing, auto, healthcare, etc. Each of the domains, however, should have userdefined subcategories that can drilled down to when needed.
1 vote 
Combine Arrays Function: COMBINE(Array1, Array2 , ...)
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#))
2 votes 
weighted randomizer function
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!
1 vote 
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
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
1 vote 
add basic functions that exist in excel for windows! Wouldn't have bought it if I had known that it didn't include these basic functions!
basic functions for excel
2 votes 
Filter/explode category in Formula Builder
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.
1 vote 
translation function
It would be a great time saver if there was a translation function that worked like a reference function. Especially if you work internationally and have to enter 2 languages in e.g. a list to make it easier to understand, this function would be very practical, because you would have to enter it once and then you could transfer it to the other cells.
For example: column A is German and column B should contain the corresponding English translations. Instead of having to translate everything manually, a function would be simpler here, which would transfer the following information: If A1…2 votes 
add Let function to Excel for macOS
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.
1 vote 
improve the filter function in excel for Mac  make it work the same as with excel for PC
improve the filter function in excel for Mac  make it work the same as with excel for PC
9 votes 
I would need to use result of a formula as the lookup value in VLOOKUP, Hlookup....
The lookup value in this set of functions (vlookup, Index, match...) need to be a value or a reference to the cell containing a value. I would need the possibility of that value being the result of another formula or function. For example : Vlookup(A2;b2:f9:3;0) where A2 would not contain a value but a formula such as =M1+m2 or simply M1
1 vote 
全環境、全バージョン、配列数式の 引数引き渡し
配列数式を 組む際に、
・セル間配列数式値の 受け渡し、
・ネスト間配列数式値の 受け渡し、
此等において、ご存じの通り、
阻害条項が 横たわっており、連れて、
名前定義を 介したり、
INDEX構文を 持ちいたり、
等、阻害への 特殊な、
対応が 求められます。又、
OFFSET構文等の、
索引関数の 結果を、
上位ネスト関数に 引き渡す際にも、かなり 以前から、
不具合が 見られるように、
なっていますし、他にも 有る、
可能性も 横たわっています。一方、
もし 此等を、
VBAで なそうと、
する場合、ループ等での 対応が、
一般的です。ですが、
此では オブジェクトタッチ数が、
飛躍的に 増え、連れて、
必要処理時間が 飛躍的に、
増加するだけでなく、プリセット機能である シート関数の、
有用性を 殺し、併せれば、
Excel 其の物の、
価値を、能力を、
毀損しています。Excelの、
持てる 能力の、
全てを 毀損させず、
余す事なく 発揮させるためにも、配列数式への 改善を、
図っては 如何でしょうか、ご検討を 願います。
1 vote 
Temporary variables in formulas
It would be amazing if you could implement a function that allows you to set a temporary variable to use within a formula! Something like the syntax used in OpenRefine's "with()" control (borrowing their syntax for my example  link to their wiki below).
Syntax:
WITH( [Function A], [Variable Name: string], [Function B] )[Function A] would get evaluated first, and then the result could be referenced within [Function B] using the [Variable Name] string (essentially as if it was a named range). With this you can reuse a value in a formula multiple times without needing to repeat the…
3 votes 
Please improve the ASC and JIS functions
Please improve the ASC and JIS functions so that:
they can apply to:
 only romajis,
 only katakanas,
 both of them
For instance, this could be like:
 ASC(Text,1) / JIS(Text, 1) would apply only to romajis
 ASC(Text,1) / JIS(Text,1) would apply to katakanas only
 ASC(Text,0) / ASC(Text) / JIS(Text,0) / JIS(Text) would apply to both, just as the present versions.This would be very helpful for a variety of usages.
The main usage would be to force romajis to singlebyte while forcing kanas to doublebyte.
In fact, in many cases, ones would prefer transform only…1 vote
 Don't see your idea?