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.

2 votes

Add an IN() function to check for existence of a value
Right now, I often use formulas like this:
=IF(COUNTIF("A", myRange)>0, ..., ...)
It's be handy to be able to just use:
=IF(IN("A", myRange), ..., ...)
This could also help with formulas where a number of different criteria are allowed:
=SUMIFS(B:B, A:A, "2016") + SUMIFS(B:B, A:A, "2013") + SUMIFS(B:B, A:A, "2010")
becomes
=SUMIFS(B:B, A:A, IN(A2, "2016", "2013", "2010"))
3 votes 
Lets users set exponential smoothing beta and alpha
In some fields, such as supply chain management, it helps for analysts to be able to set their own alpha and beta values when using the new exponential smoothing functions. I don't think it's necessary to build it into the Forecast Sheets.
2 votes 
Add a funciton to search in a string from the end (INSTRREV)
Please add a formula that works like INSTRREV in VBA.
(20160308 Dan [MS]  updated title to include INSTRREV, when merging in duplicate idea)
9 votes 
Integrate units into cells for display and mathematical operations
Allow numbers to be displayed with text (without using the concatenate), while also being able still use the numbers/text for equations. Then units can be displayed (e.g.20 mm) and referenced to be operated on via another cell (e.g. 20mm*2+5 = 205mm)
Keep reading if want more Details/explanation
Minimum way to implement would be to provide function to ignore all text for calculations (deconcatenate?) but then add it back in at the end (reconcatenate)...all in one function. This would be the quick and dirty method to get the low hanging fruit.Super slick way to implement would be to go a…
7 votes 
Root Mean Square Error (RMSE)
Please add RMSE formula to statistical function library.
3 votes 
worksheet function for returning a field inside a delimited lists
I’d like to have a function available that returns a specified field within a delimited list. I would pass the list, a delimiter and a field number as arguments to the function and it should return the value in that field.
For instance with the pipe separated list ”TEST1TEST2TEST3TEST4 TEST5TEST” in A1.
I’d like to use something like GetFieldInDelimitedList(A1;"";5) and have it return “TEST5”.Any equivalent formula will requires quite a lot of nested functions e.g.:
=MID(A1,FIND("([])",SUBSTITUTE(A1,"","([])",4))+1,FIND("([])",SUBSTITUTE(A1,"","([])",5))(FIND("([])",SUBSTITUTE(A1,"","([])",4))+1))13 votes 
string function which returns the number of occurences of a substring
I regularly have comma separated lists, and would like to know how many values there are in the string. Currently do that in VBA, but it would be nice if there was a function for that. E.g.:
A1 = "abc, def, pqr, xyz"
B1 = PARAMS(A1,[optionally]",") optionally so that you can do ; or others as well5 votes 
Improve the Match Function
Make the Binary Options of Match to work on Unsorted Data
Provide an Optional Parameter for Search Instance
=MATCH(What to Search,Where to Search,[Match Type],[Match Instance])12 votes 
Create a function ISDATE(Data)
Please, create a function ISDATE() to test if the contain of a cell is a date or not. This function exist in VBA but not in the Excel function. That's weird
11 votes 
To create a new function to Convert figures into letters
A new function in order to convert a figure for ex. 2 into two, and more difficult as 1.350, 1.698.367 etc.
2 votes 
New maths & stats functions
Like MAXIF, MINIF and SUMPRODUCT that works on Row x Column (currently need to rely on MMULT even for 1 dimensional arrays or use TRANSPOSE)
14 votes 
0 votes
 Don't see your idea?