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.

Vlookup returns 0 when looked up cell is blank
could you provide that if the cell to be returned in a vlookup or hlookup formula is blank, then the value of the formula also resolves as blank  or have this as a choice, e.g. Vlookup(c1,A1:b5,2,false,"") where "" = the value to be returned if the looked up cell is empty. The default could remain 0 if this is omitted from the formula.
7 votes 
Add Google Docs Like Unique Function
A formula to provide the unique values in a given range  takes one argument, the range to filter.
6 votes 
Sum noncontiguous data based on cell format (ie fill, font color)
Please enable SUMIF function to sum noncontiguous data in a range based on cell format (ie fill, font color)
11 votes 
Be able to use functions (eg. Concatenate) in chart titles.
Be able to use functions (eg. Concatenate) in chart titles.
3 votes 
6 votes

Add optional parameter to TRIM function to support LTRIM and RTRIM
The TRIM function removes leading, trailing, and internal spaces. It would be so helpful if it had an optional second parameter that allowed the following options:
1: remove leading spaces
0: remove leading, trailing, and internal spaces (default)
1: remove trailing spaces
2: remove internal spaces4 votes 
formulae for column letter to number & vice versa
I know there are existing options, but they are longwinded. Surely adding 2 very simple and memorable formula like the below would help plenty of people:
=COLNUMBER("D") would return 4
and
=COLLETTER(4) would return D
8 votes 
Presentation of Nested Formulae
Debugging complex nested formulae and functions within a single cell can be difficult and requires a careful check to be kept on the level of parentheses. As an additional formula auditing tool, instead of presenting a formula in a single line it would be much clearer to present each level of nesting (parentheses) on a lower row. Like this the top level function is presented in the top row, the first level of nesting at the same position along the row the but dropped down a row, etc. so that the formula steps down a row (and up again) as…
9 votes 
A function to return the target address (URL) of a HYPERLINK cell
Currently we have to create a userdefined function to get the URL address from a cell containing a hyperlink.
e.g. rangeObj.Hyperlinks(1).Address
Perhaps adding to the existing CELL() function?
=CELL("hyperlink","A1")When copy/pasting data from websites to Excel the hyperlinks are retained but can't be extracted. (If Power Query Web tables could bring the hyperlinks in too, that would be helpful. Perhaps as expandable column with the displayed text.)
22 votes 
New *IFs function to accept any aggregating function
The *Ifs functions are very popular among excel users, it seems like every new version of excel adds a few more of these functions,and I see a bunch of requests on here to add even more. perhaps the best approach may be to combine them into a Ifs function to rule them all.
it would be similar to existing IFS functions, but the first parameter would let you define what to do with the matching data.
e.g. =Sumifs(A:A,B:B,E1,C:C,F1) could become =NewFunction("Sum",A:A,B:B,E1,C:C,F1)
=Averageifs(A:A,B:B,E1,C:C,F1) could become =NewFunction("Average",A:A,B:B,E1,C:C,F1)
this would allow the creation of new IFS functionality like StddevIfs, VarPIfs, MedianIfs, ModeIfs, ProductIfs…
14 votes 
Excel Currency conversion
Currency conversion online just like google spreadsheets function =GoogleFinance("CURRENCY:USDEUR")
5 votes 
being able to select a large number of formulas and lock every =ColumnRow to =$Column$Row with the push a button would save time.
Being able to change a large number of selected formulas from relative to the formulas being locked on the column and row each formula references; with the push of one button would save a great deal of repetitive find and replace time.
4 votes 
Make INDIRECT works with closed workbook
Make INDIRECT works with closed workbooks!
9 votes 
Function to convert UNIX timestamps to Excel dates
It would be really useful to have a function that could convert UNIX timestamps (number of seconds since 1/1/1970 00:00:00) to an Excel time/date. UNIX timestamps are very widely used in the world of computer science and embedded systems, and being able to process them easily in Excel would be a big win.
The function should handle noninteger values, to allow us to use it with e.g. JavaScript timestamps (which are the number of milliseconds since 1/1/1970).
5 votes 
Sort Function
We need a SORT Function  Like So
=Sort(Range/Array,SortCol,Order)
This should be able to handle both 1d/2d Ranges / Arrays and return an array of Sorted values of the same dimension
It should be based on a very fast sort algorithm6 votes 
Add functionality to vlookup the last column in the array so we dont have to count columns
When we use the vlookup function, the column number to return must be known, but more often than not, we return the rightmost column. So it would be nice if we could just type "LAST" in the function instead of a number which returns the last column.
vlookup(A1,Array,LAST,0)
Applies to hlookup too.
5 votes 
SUMPRODUCTIF AND SUMPRODUCTIFS
Allow and extension of the SUMIF/SUMIFS and SUMPRODUCT function to be SUMPRODUCTIF or SUMPRODUCTIFS where excel will perform the sumproduct function on the rows that meet the criteria.
3 votes 
Trace Precedents, Trace Dependents, and Remove Arrows should be integrated into the Undo stack, not clear it
For example, use the formula =A1 in B1. If you use Trace Precedents on B1 or Trace Dependents on A1, you will lose your Undo history. If you make further edits and then use Remove Arrows, you will also lose your Undo history. My suggestion is that these actions should be Undoable. That is, they should be integrated into the Undo stack rather than clear it.
28 votes 
image function similar to google spreadsheet
Need an image function similar to google spreadsheet which displayed a linked image without actually embedding the image into the spreadshee
10 votes 
office 365 vs office 2016 professional plus
can the new features that are available in office 365 professional plus be added to office 2016 professional plus? features like https://blogs.office.com/2016/02/23/6newexcelfunctionsthatsimplifyyourformulaeditingexperience/
8 votes
 Don't see your idea?