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.

Count number of the data in one column which is bigger than the value of a cell in another tab
Currently, we can only make criteria in formula 'countif' or 'countifs' as a number, a comparison with a predefined value, a cell, or a word.
It will also be helpful if we can also make the criteria as a comparison with a cell.
For example:
tab 1 contains a lot of dates in one column
tab 2 contains any other dates in one column
We can count the number of the dates which is bigger than each date in tab 2 through this function.2 votes 
Please implement main historical and astronomical chronology (mini. Gregorian Calendar, Julian calendar, julian day, may be also Roman Calen
It would be very helpful to use Excel as most popular tool also in historical works.
2 votes 
4 votesDan Battagin [MS XL] responded
Hi Tarun,
While this isn’t a single function to do what you want, you can accomplish this today with the formulas outlined on the following page.
Hope that helps,
Dan [MS] 
Add a hashbytes function like in tsql
TSQL has a HASHBYTES function which takes two parameters, the hashing function, and some input and then returns a hash.
HASHBYTES ( '<algorithm>', input )
<algorithm>::= MD2  MD4  MD5  SHA  SHA1  SHA2256  SHA2512
If conditional formatting highlight duplicate values blows up on long strings, at least I could use this to find duplicate hashes.
5 votes 
Expand Excel to introduce “Dual Cell Capability”.
The problem with Excel is that every formula is a total recalculation. You can’t add a calculated result to a previous value in a cell to come up with a new value. You have to keep all the data in the worksheet and recalculate and it keeps growing larger and larger.
Expand Excel to introduce “Dual Cell Capability”. When required by the application, DCC would allow you to define a formula in one of the cells (just as it does now) but also carries persistent data in the other partner cell that can be recalculated and/or updated by the formula…1 vote 
Change GetPivotData to read the pivot cache
A recent survey of the most evil Excel functions showed an unexpected (to me) result. Getpivotdata topped the list.
One of the major reasons for this is that it only works off whatever Field names are visible, so that when the user changes the visible row or column fields getpivotdata stops working.
if it read the pivotcache directly then this problem would be solved and Getpivotdata would be a lot more robust.3 votes 
Automatically remove repeat numbers
Need to post rows in once excel sheet and have them Automatically remove from another sheet. IE Sheet one contains numbers and account data per row sheet 2 contains repeat numbers with no account data. Remove any rows with a repeat number based off the first cell in that row.
1 vote 
Make 3D reference work with more functions.
My favorites would be sumif(), countif(), sumifs(), countifs(), sumproduct(), match(), and index(), and offset().
2 votes 
Make a simple TIMESTAMP fucntion so you don't have to use VBA or formulas with circular references.
There doesn't seem to be a simple way to create a static time stamp that is created when data is entered and/or changed in another cell. Both methods I know require a formula which can create a circular reference, or using VBA.
9 votes 
Add an IFERROR to VBA
An easier "IFERROR" function. If there's an error, then do something, otherwise use the original formula; shouldn't have to enter the same formula twice.
3 votes 
Add "LeftOf" and "RightOf" text functions
Would love to see one function that returns all text from the left (or right) of a specified character. As it is now, you must know the number of chars you want to return.
LeftOf(text,string,num)
text is the text or cell you are manipulating
string is the char or chars you are looking for
num is the occurrence of string from the left (1st, 2nd, etc)A2 = "Excel is a great utility"
LeftOf(A2," ",3) = "Excel is a"
RightOf(A2,"a",1) = "t utility"3 votes 
2 votes

State programming
I am missing a currentstate programming feature. e.g.
If my application is in state X (state cell A2=X) at the time I key in a value (in cell B5), then cell B7 must be set to Y, and stay unchanged when the application enters another state, until I enters a new value in cell B5.
i.e. it is the state value that  only at keyin time  controls the setting of another cell.=STATE A2, B7 {currrent cell:= entered value}{If A2=X;B7=Y;none}
Lars W.
1 vote 
Builtin function version of Histogram. I made my own with formulas, but would prefer not to have to.
I constructed a histogramcalculator, so that it automatically updates, but it's curious such a function is not builtin.
2 votes 
Provide functions that work better with dates.
For example, have a function that actually gives the day of the week spelled out instead of a number.
2 votes 
Allow types of cells to be presented in different colors. (locked, formula, etc
Creating, editing, etc. is so much easier when categories of cells can be presented in different colors. For example, when a cell is locked it has a different color than an unlocked formula. It helps prevent accidental changes to formulas.
4 votes 
Max  MIN
I understand that this is a really easy function to do yourself. But I can imagine all the people feeling dumb for searching for it for a few minutes before resorting to the peasant method of typing two functions that are always put together in almost every Excel spreadsheet ever.
1 voteCan you give a bit more detail on what you’re looking for here? I’m not sure I understand from your description.
Is it the MAX of a range minus the MIN of that same range?
Cheers,
Dan [MS] 
I would like a simple global search of a spreadsheet. One has to go to options, find a dropdown bar, click within, etc. Too many steps.
Please make a simpler global search of a entire spreadsheet (workbook) instead of the many steps needed to search beyond the worksheet. Why not radio buttons on the search box?
2 votes 
New bitwise functions
The current bitwise functions are of such limited use they should be replaced. Below are some ideas for the next round of bitwise functions:
• Have arguments for word size (in bits) and signedness for every bitwise function. Exception: bitwise left shift is unaffected by signedness.
• Add a BITNOT function.
• Support multiple arguments for bitwise AND, OR, and XOR.
• Possibly add bit pattern reinterpretation to the CONVERT function. For example, if I want the singleprecision floatingpoint representation of the integer 4, I should get 0x40800000 = 1082130432.2 votes 
Add angles to the CONVERT function
The DEGREES and RADIANS functions can be used to convert between degrees and radians. However, there are at least 2 other ways to measure angles: gradians and turns. Please add angle support to the CONVERT function and deprecate DEGREES and RADIANS. Excel is currently worse than a scientific calculator when it comes to angle conversion choices.
2 votes
 Don't see your idea?