That's it: PROCX and CORRESPX in Portuguese versions of Excel to keep the same standard of the other functions.

🇧🇷🇵🇹🇦🇴🇲🇿🇨🇻

Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!

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.

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.

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.

Please add support for Tezos in this function.
Tezos is very popular and provides formal verification for Smart-Contracts, on-chain-Governance and it is the first Blockchain which is amendable (without the need of so called "Hardforks"). Ticker symbol is $XTZ.

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.

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.

A formula to convert text to a formula; which is essentially the exact opposite of the FORMULATEXT function, or in a way, what the INDIRECT function does with cell references but with formulas.

Proposal for a built-in 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 beginner-level users would like probably a predefined parametric function, sg like this:
=COUNT.DISTINCT([RANGE])

Thank you.

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.

I have to use a OFFSET fuction for a dinamic array and I was thinking is a good idea have the posibility to use a new function for detect the last column/row in an area like in VBA. Something like:
=OFFSET(A1,1,0,1,COUNTA(RIGHTEND(A1,1)))

where RIGHTEND be like
=RIGHTEND(cell_reference,0 or 1 can be right or left)

Same case for DOWNEND
= DOWNEND(cell_reference, 0 or 1 for up or down)

It can be vey practical.

Thanks!

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.

Make The [Search mode] parameter to accept values as below
1,2,3 etc to mean 1st instance, 2nd instance etc from the top
-1,-2,-3 to mean 1st instance , 2nd instance etc from bottom

The search algorithm is already specified in the [Match Mode] parameter so there is no need to duplicate it again in [Search mode]

A very much need function which should allow Excel users to convert number to word.

Example :
1. $ 450.00 it should convert to US Dollars four hundred fifty and zero cents only.
2. SAR 450.00 it should convert to Saudi Riyals four hundred fifty and zero halalas only.

Note : the conversion should be based on regional setting and user should be able define the currency code.

=SpellNumber([cellReference],"CurrencyCode")

Mohammed A Elrify
Mohammed A Elrify Occasional Contributor

4m ago

Suggested to Microsoft EXCEL
By creating the advantage of the proposed Function and formulas recommended
Such as recommended pivot tables and recommended charts

For 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 idea

When selecting the data ranges that have the information you want, enter the $ on the range: XLOOKUP(A5,$D$1:$D$80,$G$1:$G$80)
I'm working 30 years with spreadsheets and I've probably use VLOOKUP without the $ 5 times. People with less skills forget to include the $ and the formulas don't work properly and they have to call me for help.