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.

SUMCOLS and SUMROWS functions for Dynamic Arrays
Create new functions that SUM each column in a dynamic array (SUMCOLS(Ref#)) to produce a row of totals, and SUM each row to produce a column of totals (SUMROWS(Ref#))
Also COUNTCOLS, COUNTROWS, AVERAGECOLS, AVERAGEROWS, but these are less important than SUMCOLS & SUMROWS.
193 votes 
Translate XLOOKUP and XMATCH to PROCX and CORRESPX in Portuguese
That's it: PROCX and CORRESPX in Portuguese versions of Excel to keep the same standard of the other functions.
🇧🇷🇵🇹🇦🇴🇲🇿🇨🇻
304 votesThanks for posting this issue and up voting it! I’ve passed this along to our localization team. – Joe McDaid

Add a Split dynamic array function
Add a dynamic array function to split apart a delimited range. See attached file for an example.
89 votes 
SUBSTITUTES function supporting arrays of "find" and "replace" parameters
From time to time, users need to remove multiple characters from a string. For example, you might want to remove all punctuation, or all accented characters.
Right now, you have to do that with a lengthy nested formula using the SUBSTITUTE function. Such formulas are hard to read and challenging for a novice to debug. Or you could write a VBA userdefined function that performs each of the substitutions for you.
The better approach would be a SUBSTITUTES function that works like SUBSTITUTE but accepts an array (or range of cells) for the Find parameter, and possibly also for the…
73 votes 
Release XLOOKUP to the world!
Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!
132 votes 
Allow UNIQUE() to operate on a rectangular range, returning all unique values
The new Dynamic Array function UNIQUE is awesome. It can return all of the unique items in a column or in a row. But it would be nice if the second argument could accept a 3 to indicate cellbycell.
For example, see the screenshot below.42 votes 
Please create a FILTERJSON (FILTROJSON) worksheet function
Hi. How about creating a FILTERJSON function? It would make our life easier allowing us to get JSON data with less workarounds.
Oi. Que tal criarem uma função de planilha FILTROJSON? Tornaria a nossa vida mais fácil nos permitindo obter dados em formato JSON com menos soluções alternativas.
🇺🇸 English: FILTERXML > FILTERJSON
🇨🇿 Czech: FILTERXML > FILTERJSON
🇩🇰 Danish: FILTRERXML > FILTRERJSON
🇳🇱 Dutch: XML.FILTEREN > JSON.FILTEREN
🇫🇮 Finnish: SUODATA.XML > SUODATA.JSON
🇫🇷 French: FILTRE.XML > FILTRE.JSON
🇩🇪 German: XMLFILTERN > JSONFILTERN
🇬🇷 Greek: FILTERXML > FILTERJSON
🇭🇺 Hungarian: XMLSZŰRÉS > JSONSZŰRÉS
🇮🇹 Italian: FILTRO.XML > FILTRO.JSON
🇳🇴 Norwegian:…72 votes 
"Excel found a problem with one or more formula references"  Please tell me where!
One of my least favorite messages that Excel provides is:
"Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."
But I can never find the bad references. It's usually buried somewhere very deep, in a chart series formula, or in a name definition, or who knows where else.
If Excel finds a problem, please Excel, tell us where it is.
160 votes 
Add Corkscrew function for dynamic arrays
Corkscrew accounting is fundamental to Financial Modeling. It is where opening balances are carried over from closing balance of prior periods..
=OpeningBalance(FirstPeriodBalance, PriorBalances)
Where FirstPeriodBalance is the first period's opening balance and PriorBalances is an array of closing balances for each period.
The cell containing this function will return FirstPeriodBalance. The SPILL range will contain the n1 closing balance array value.
https://corporatefinanceinstitute.com/resources/excel/study/corkscrewcalculation/
10 votes 
XLOOKUP to return an array of ranges
Currently XLOOKUP can return an array of return values, given an array of search values, OR a range corresponding to a single search value. Like other functions, it does not return an array of ranges but, rather, truncates the calculation.
This may have been acceptable in the past when the expectation was to copy formulas across to return values that logically form an array. As dynamic arrays receive increasing use, the expectation will change and the failure of a range to spill will be far more problematic.
14 votes 
SORT function with sort_order argument 0 as random
Hi. You could create a new option 0 as the sort_order argument of the SORT function. Today we have 1 for Ascending, 1 for Descending and then we would have 0 representing shuffle, random order.
15 votes 
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.
149 votes 
Add a MONTHDIF function
The formula should work like the YEARFRAC function. It should calculate partial months on either end of the dates. So starting 1/15/20 should calculate as 16/31 days or 0.516.. months, and ending at 6/5/20 should calculate as 25/30 day or 0.8333.. months. Currently, I have to use a ridiculously long formula to achieve this.
40 votes 
[Excel Currency Conversion Function] add Tezos XTZ (Cryptocurrency)
Please add support for Tezos in this function.
Tezos is very popular and provides formal verification for SmartContracts, onchainGovernance and it is the first Blockchain which is amendable (without the need of so called "Hardforks"). Ticker symbol is $XTZ.49 votes 
Disable the "SPILL!" error function completely
Disable the SPILL! error fucntion/code completely, it is garbage and wrongfully tags formulas with SPILL! Having to go in and change formula syntax to satisfy this random error is ridiculous.
3 votes 
COLUMNA() returns the letter(s) where as COLUMN() returns a number
column() is great, as usually we want the column NUMBER
BUT when you want the column LETTER(s), something like
COLUMNA()
could return it.
I know you can use
=SUBSTITUTE(ADDRESS(1,COLUMN(A1),4),"1","")
but it's pretty longwinded...to clarify
=COLUMN(AB1) returns 28
=COLUMNA(AB1) returns AB8 votes 
vlookup case sensitive
very simple,VLOOKUPs are case insensitive, VLOOKUPS should be case sensitive. One use case are Salesforce reports. They produce 15 character Ids that require case sensitivity functionality in order lookup against.
7 votes 
Modificación para función LET(...)
Buen Día.
Sobre la función LET().
¡Por favor les suplico que añadan un primer argumento NombreDeLaFormula!
LET(NombreDeLaFormula;Variable;Valor;...;Formula)
De esta forma sería posible hacer referencia a ella en otras fórmulas por su nombre y además da una pista imprescindible para poder entender mejor de que va dicha fórmula sin tener que asignar un nombre a la referencia.
Con ello quedaría "casi" perfecta.
=LET(VolumenParalelepipedo;x;VarAncho;y;VarLargo;z;VarAlto;x * y * z)
=LET(x;VarAncho;y;VarLargo;z;VarAlto;VolumenParalelepipedo;x * y * z)1 vote 
randarray in tables
RANDARRAY does not work in Excel tables. It results into #SPILL!
Would be nice if RANDARRAY did work int tables.1 vote 
DONT'T CHANGE MY FORMULA!!!!!!!
How about keeping the formula intact, returning a #REF result and NOT editing the formula with a #REF comment. This stupid idea prevents one from following the formula back and evaluating what the error is, or what cell it's referencing. Who ever thought of doing this should have some training! If one receives a spreadsheet developed by someone else, they may not know how the formulas work/reference, but leaving the formula intact gives the opportunity to understand what the result should be. CHANGING the formula should NEVER be an automatic option by the software!!!!!
7 votes
 Don't see your idea?