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.

Convert Dynamic Arrays into Tables
The new Dynamic Arrays make possible to automatically fill down formulas. Tables can also fill down formulas. Microsoft Excel Team could make both features be compatible so we could convert Dynamic Arrays into Tables making them expand and shrink according to the main formula.
42 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.
973 votesHi everyone,
Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/enus/article/getastockquotee5af3212e0244d4cbea0623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.
We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

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 idea72 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 .
87 votes 
COUNT.DISTINCT Values
Proposal for a builtin function for: Count distinct/unique values in a range
There might be a dedicated function for counting distinct values in a specific range.
Currently the following function is a solution:
=SUMPRODUCT(1/COUNTIF([RANGE],[RANGE]))However beginnerlevel users would like probably a predefined parametric function, sg like this:
=COUNT.DISTINCT([RANGE])Thank you.
30 votes 
Add a CONTAINS("find_text","within_text") Function
Excel's own documentation recommends pairing the ISNUMBER and SEARCH functions to accomplish this, but I still have team members asking on a regular basis for a function that returns whether a string is found within a given cell. An out of the box CONTAINS() function would go a long way for usability.
10 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.).25 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)
19 votes 
Ordinal Position Function
A function which returns ordinal position of one specific element in an array as a number. Alternative name occurrence.
So for example if the array was like this
A1 Dave
A2 Fred
A3 Jim
A4 DaveThen Ordinal(A1:A4,A1) would return 1 eg the 1st Occurence of Dave
Ordinal(A1:A4,A2) would return 1 eg the 1st Occurrence of Fred
Ordinal(A1:A4,A3) would return 1 eg the 1st Occurence of Jim
Ordinal(A1:A4,A4) would return 2 eg the 2nd Occurrence of DaveFunction Format something like
Ordinal(lookup array, lookup cell, optional reverse)
Lookup array could be vertical with a width of 1 column or horizontal…2 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.
40 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 Fernandes30 votes 
Perform Calculations (Sum, Count, If, etc.) Based on Cell Color
Allow users to create formulas and that perform specified operations with data/values from only cells with a chosen background color, from a range of cells.
For example, in a range of 10 cells (A1:A10), only 3 cells have been colored yellow (either by the user or by a specified condition). A user can create a formula, such as =SUM or =COUNT or =AVERAGE, that will only use the cells colored yellow to determine the result. All other cells in the range, regardless of background color, will be excluded from the formula's result.
Alternatively, the same functionality can be achieved based…
17 votes 
Protect the cell formatting property in the formula.
Which it has number in one of the cells in Excel, it has letter other of the cells in Excel. When I combine these two cells, I want to display the cell with the letter as a superscript in a single cell. I need this feature in the preparation of the table in the scientific article. However, there is no related menu in Excel. I expect you to help me with this.
3 votes 
Rounding Error in Excel
You have a serious rounding error issue in excel that I confirmed with your help desk they could recreate.
Go into excel and type 3 in cell B2
In B3 type the formula =B2+0.1
Copy the formula down to cell B36
Cell B32 should read 0 exactly but does not 1.53E15
I had this rounding error turn up when creating a more complex spreadsheet and could not understand why there is an error
if you format the cells to 30 decimal places you will see that when 0.1 is added to 1.1 the answer returned is 0.999999999999998000000000000000
not 1.00000000000000000000000000002 votes 
1 vote

Allow wildcards to be used with IF statements
I think the IF function should allow wildcards to be used. Take a look at the attached file. I'd rather write the below function than what I have show in the attached filed:
=IF(N2=2010??, "2010", IF(N2=2011??, "2011",...etc.)
2 votes 
Excel is wrong in calculating x^2
If you type in for example =6^2, Excel gives you 36. This is incorrect. Excel is assuming you mean =(6)^2. But 6^2 is different.
You can see this when you factorise. 6^2 = (6)*(+6) = 36.
Whereas (6)^2 = (6)*(6)=36.
Now if you type in = 06^2, only then does it give you the correct answer of 36.
This error goes against millennia of algebraic convention.
Plot the graph y=x^27x12 and then plot y=7xx^212. These two expressions are identical, yet Excel gives very different traces (the latter of the two gives the correct graph).
Another way to correct x^2 would…
2 votes 
Name a dynamic array (rather than use "A1#" notation)
The new dynamic array notation is incredibly powerful, but one thing that makes formulas complicated is the "A1#" notation when used in formulas.
It would be great if you could (easily) assign a name to it in the same way that you can name an Excel table.
It would be much easier to see:
=SUMIFS(TABLE1[totals],TABLE1[dept],departments)
than
=SUMIFS(TABLE1[totals],TABLE1[dept],B1#)
I am able to define a named range for these values, but that is a bit clunky. It would be great if the naming was exactly the same as Table naming (e.g. in an ARRAY context menu like the TABLE context menu).
10 votes 
Fuzzy Match in Power Query Excel
Include Table.FuzzyNestedJoin fuzzy match capability in Power Query Excel
3 votes 
A formula to calculate the direction of a vector from 0 to 360 degrees.
The formula is working for any value of x and y, is not using any trigonometric function and give the result with an accuracy of one billionth of the degree.
f(x , y)=180/pi()*(pi()/8*sign(x*y)*sign(y^2x^2)+pi()/4*(42*sign(y)sign
(x*y))pi()/2*(1sign(y^2))*(sign(x^2)+sign(x))
n=0
sign(x*y)*Σ(1)^n*((abs(x)*(sqrt(2)1)^(x^2y^2)abs(y)/
n=17
(abs(x)+abs(y)*(sqrt(2)1)^(x^2y^2)))^(2n+1)/(2n+1))2 votes
 Don't see your idea?