Excel for Windows (Desktop Application)
Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback inapp instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.
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.

Function and formulas recommended
Mohammed A Elrify
Mohammed A Elrify Occasional Contributor4m ago
Suggested to Microsoft EXCEL
By creating the advantage of the proposed Function and formulas recommended
Such as recommended pivot tables and recommended chartsFor example, the work of options for the user
For example if he wanted to compile on terms, he would have the formula SUMIFS ready and only a choice
Also like the search that VLOOKUP uses
And so on
I hope the Microsoft community will support and encourage this idea63 votes 
Directions from 0 to 2pi 1)atan(x,y) 2)atan(E,N) and from pi to +pi 3)atan2(x,y)
1)atan(x,y)=pipi/2*(1+sgn(x))*(1sgn(y^2))pi/4*(2+sgn(x))*sgn(y)
sign(x*y)*atan((abs(x)abs(y))/(abs(x)+abs(y))) when x=x2x1 ,y=y2y1
2)atan(E,N)=pipi/2*(1+sgn(N))*(1sgn(E^2))pi/4*(2+sgn(N))*sgn(E)
sgn(N*E)*atan((abs(N)abs(E))/(abs(N)+abs(E))) when N=N2N1 ,E=E2E1
3)atan2(x,y)=pi/2*(1sgn(x))*(1sgn(y^2))+pi/4*(2sgn(x))*sgn(y)
sgn(x*y)*atan((abs(x)abs(y))/(abs(x)+abs(y))) when x=x2x1 ,y=y2y1
The above fuctions give the directions in the 4 quadrans for all the pairs of dx and dy.
For dx=dy=0 the result is indefinite .
81 votes 
Random value generation
Idea:
Excel might have a builtin function for generating random values.
Two 1dimensional and identical long ranges can include inputs for both the values to be returned and the corresponding weights.
E.g. ["apple","orange","apricot"] [10,20,30] > 30/(10+20+30)=50%, 50% is the probability that the returned value is "apricot".Rationale:
This solution can help to generate datasets with predefined parameters. This can help in teaching, training and modeling activities.
The same approach can be applied for generating timestamps with predefined parameters. This could be utilized for data analysis (monthly, weekly, daily seasons, distributions etc.).23 votes 
Add cell reference to Data Validation Messages (Input Message, Error Alert)
Please add the ability to use cell references or formulas in the Data Validation Messages (Input Message, Error Alert).
This would make possible to use variable contents.Thanks,
Fernando Fernandes21 votes 
Make the Evaluate Formula dialog box resizable
The evaluate formula box is unusable with large and/or CSE formulas. Please just make it resizeable. Thank you.
21 votes 
Add a BETWEEN function & operator
The BETWEEN function is in Microsoft Access, it should also be in Excel. And one could use the operator >< to represent it. So you would have:
=15>A1<25 or =BETWEEN(A1,15,25)
="A">A1<"C" or BETWEEN(A1,"D","L")
=DATE(2020,1,1)>A1<DATE(2020,4,5) or BETWEEN(A1,DATE(2020,1,1)DATE(2020,4,5))wildcard (*, ?, and ~) could be applied:
="D">A1<"L??" or BETWEEN(A1,"D","L??")
Use the same definition of BETWEEN as MS Access.
9 votes 
COUNTIFS / SUMIFS with OR  COUNTOR, SUMOR
Countifs or Sumifs function use all criteria as AND. Instead 2 more formula can be added such that all criteria are treated as OR. Suggested Names of Formula are
COUNTOR, SUMOR37 votes 
Allow column name to be used in vlookup
Allow the VLOOKUP formula to recognise a column label in place of the column count. This is a sorely lacking functionality when referencing large data sets that can easily extend to column counts of 50 or more.
Example: =VLOOKUP(A2,F:AM,AM,false) instead of =VLOOKUP(A2,F:AM,34,false)
2 votes 
Add TopN optional parameter for new Dynamic Array functions
The new Dynamic Array functions are awesome, but it would be nice if we could tell them to only return the TopN results via an optional parameter. So =SORT(A1:A10,,,5) would just return the top 5 items after the sort was done.
6 votes 
To be able to select the last instance of a text in SUBSTITUTE or FIND
The SUBSTITUTE function allows the user to specify the instance of a text to be replaced. However, there are many cases where one wishes to identify the last instance in a list where the number of instances varies (example: a list of files with multiple folder paths of different lengths; I want to identify the final '/' so that I can extract just the file name).
My suggestion is a third option for how the [instance num] in the function SUBSTITUTE(text, old_text, new_text, [instance_num]) is used; the user should be able to specify something like "Final" (or some other string)…
5 votes 
New Lookup Function for Simple Table Lookups
Excel has many functions about lookup and reference, e.g. VLOOKUP, OFFSET, MATCH etc.
However, over the years with Excel I have always missed a very useful lookup function from Lotus 123. It was called XINDEX and was used for very basic lookups in a two dimensional table. XINDEX had three arguments:
1. A range name, e.g. TEMPERATURE which could be A1:M6.
2. Header name of column to search in, e.g. one of the twelve calendar months
3. Header name of row to search in, e.g. Boston, London, Beijing, Melbourne or Kinshasa
In our example table we could for instance have…3 votes 
Pull Current Stock Prices and Historical Data Into Excel
Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.
It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.
864 votesProgress! As of this morning, we’ve begun enabling the first iteration of Excel’s new data types for a percentage of Office Insiders, including the ability to pull and refresh live stock quotes (and other financial data) straight in to Excel! We’ll be increasing the percentage of Insiders with access to the feature over the coming days and weeks, so if you don’t see it right away please hang in there!*
We acknowledge that right now this is only half of the suggestion (pull current stock prices), but historical data is in our sights and we’re planning to add this and many other improvements to stock and financial data. Your feedback thus far has been immensely valuable in helping us plan and design this work, and we look forward to your continued suggestions for how we can improve to better meet your needs
Again, we genuinely appreciate your involvement as we…

Allow names being entered as array formulas
Allow names being entered as array formulas
3 votes 
I would like to be able to add cells based on their cell color.
I would like to be able to add cells based on their cell color. Add cell properties to SUMIF or functions to Conditional Formatting
3 votes 
MID function  Make the 3rd argument optional
Change the MID function so the third argument (num_chars) is optional.
>If left blank, it would just pull the rest of the text string.
>If populated, it pulls that number of characters, just like it has always done.I typically use MID to extract the rest of the text string, starting in the middle. Right now I put LEN(A1) or 10000 in the 3rd arg to ensure it pulls enough characters. If that were the default, it could be done to speed up processing.
This would still be backwards compatible with previous versions of Excel since all existing functions would…
3 votes 
Live exchange rates in excel (compliment to the new stock features)
The new stock feature only displays stock prices in the currency on the exchange. The ability to convert between different currencies (ether in the stock feature or as a separate function) would be great and remove the need for many (including me) to copy paste exchange rates from the internet.
5 votes 
Create a simple NEGATIVE() function
Consider creating a NEGATIVE() function. This is not the same as ABS(). Rather for any number N in cell X# NEGATIVE(X#) function = 1*(N). Example: Cell F3 = 52.73. NEGATIVE(F3) = 52.73. And NEGATIVE(NEGATIVE(F3)) = 52.73.
1 vote 
Removing "x" number of characters from a string without knowing string length
I think it would be very useful to have functions similar to LEFT and RIGHT that tell Excel how many characters to remove instead of how many characters to keep.
An example: After extracting a specific chunk of data from another cell (using a complex formula), if I want to remove any more characters (units of measure, etc...) I would need to either have a helper column, or more than double the current formula to extract all that text for a LEN measurement, then extract all that text again for the removal of a few characters from the end.Having…
3 votes 
Fix the longstanding Excel bug that stops Ctrl+H searching and replacing in Values and in Comments. 64bit MS Office I
Fix the longstanding Excel bug that searching and replacing in Values and in Comments unavailable when using Ctrl+H. I just got upgraded to 64bit MS Office and this very valuable function has simply stopped working for me. The issue doesn't affect every instance of Excel, but even so the Internet is thick with people posting the same issue since at least 2007, so c'mon Microsoft, how's about you fix it!!
1 vote 
Should be able to add comments to formulas like you can in Power BI and Power Query
Need the ability to add comments to formulas like we can in Power BI and in the Power Query Advanced Editor.
2 votes
 Don't see your idea?