Feedback by UserVoice

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 in-app 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 third-party 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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. "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.

    40 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. [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 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.

    47 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

    21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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.

    52 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Pull Current Stock Prices and Historical Data Into Excel

    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.

    1,013 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    371 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Hi everyone,
    Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

    One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

    We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

  6. COUNT.DISTINCT Values

    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.

    47 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Function and formulas recommended

    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

    74 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    20 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Have a date function that is shows the date of when a data point was entered

    We'd like to have a function in which we could see the date of when a data point was entered into the system. Like that we wouldn't have to enter the date manually every time we entered a data point into the spreadsheet. it would be like an if statment, example( =IF(B3<>" ",DateOfEntry()," ")) the function itself would be the "DateOfEntry()" the issue we have with Today() is that it updates every day and therefore every time we enter the spreadsheet the date information is updated to the current date and we arent able to have proper tracking of the…

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Directions from 0 to 2pi 1)atan(x,y) 2)atan(E,N) and from -pi to +pi 3)atan2(x,y)

    1)atan(x,y)=pi-pi/2*(1+sgn(x))*(1-sgn(y^2))-pi/4*(2+sgn(x))*sgn(y)

    -sign(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

    2)atan(E,N)=pi-pi/2*(1+sgn(N))*(1-sgn(E^2))-pi/4*(2+sgn(N))*sgn(E)

    -sgn(N*E)*atan((abs(N)-abs(E))/(abs(N)+abs(E))) when N=N2-N1 ,E=E2-E1

    3)atan2(x,y)=pi/2*(1-sgn(x))*(1-sgn(y^2))+pi/4*(2-sgn(x))*sgn(y)

    -sgn(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

    The above fuctions give the directions in the 4 quadrans for all the pairs of dx and dy.

    For dx=dy=0 the result is indefinite .

    87 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Convert Number to Word (SpellNumber)

    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")

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add a CONTAINS("find_text","within_text") Function

    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.

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Text to Formula

    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.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow Data Validation List function to use the new "UNIQUE" formula

    The new "UNIQUE" feature is fantastic and it would be fantastic if you could use this function to create a dynamic list in a data validation list using indirect, rather than creating a separate dynamic list using the unique function and then creating a dynamic named range for this and then using the indirect function in a data validation list.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. upgrade vlookup() (and hlookup()) so that you can provide the column header text instead of column number. i.e. database search - dget()

    Excel has the DGET() function that allows a database search. You give the name of the column it should find the match in, and the name of the column where the value should be returned to. If vlookup can be upgraded to be similar, then it will be much more powerful:

    Example:
    newVlookup(value, data range, match column, return column, match type)

    newVlookup(Sheet1!A1,Sheet2!A:E,"Order Number", "Order Description", false)

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Function to give list of conditions to ANY function

    Say you have a function like FIND() that takes a single item to search for. If you have seven items to search for, you have to do them all separately. Yet FIND() cannot be upgraded (aside: for an obviously useful thing) without lots of years of us asking for it here and finally seeing, maybe, something.

    The idea here is to have a funciton whose sole purpose is to pass an argument to the function wrapped around it, holding "open" so-to-speak, and after the first argument's pass is over, moving on to do it again with the second argument's value.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow column name to be used in vlookup

    Allow the VLOOKUP formula to recognise a column label in place of the column count. This is a sorely lacking functionality when referencing large data sets that can easily extend to column counts of 50 or more.

    Example: =VLOOKUP(A2,F:AM,AM,false) instead of =VLOOKUP(A2,F:AM,34,false)

    22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Excel is wrong in calculating -x^2

    If you type in for example =-6^2, Excel gives you 36. This is incorrect. Excel is assuming you mean =(-6)^2. But -6^2 is different.

    You can see this when you factorise. -6^2 = (-6)*(+6) = -36.

    Whereas (-6)^2 = (-6)*(-6)=36.

    Now if you type in = 0-6^2, only then does it give you the correct answer of -36.

    This error goes against millennia of algebraic convention.

    Plot the graph y=-x^2-7x-12 and then plot y=-7x-x^2-12. These two expressions are identical, yet Excel gives very different traces (the latter of the two gives the correct graph).

    Another way to correct -x^2 would…

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Random value generation

    Idea:
    Excel might have a built-in function for generating random values.
    Two 1-dimensional and identical long ranges can include inputs for both the values to be returned and the corresponding weights.
    E.g. ["apple","orange","apricot"] [10,20,30] -> 30/(10+20+30)=50%, 50% is the probability that the returned value is "apricot".

    Rationale:
    -This solution can help to generate datasets with predefined parameters. This can help in teaching, training and modeling activities.
    -The same approach can be applied for generating timestamps with predefined parameters. This could be utilized for data analysis (monthly, weekly, daily seasons, distributions etc.).

    25 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow wildcards to be used with IF statements

    I think the IF function should allow wildcards to be used. Take a look at the attached file. I'd rather write the below function than what I have show in the attached filed:

    =IF(N2=2010??, "2010", IF(N2=2011??, "2011",...etc.)

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Fuzzy Match in Power Query Excel

    Include Table.FuzzyNestedJoin fuzzy match capability in Power Query Excel

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 50 51
  • Don't see your idea?

Feedback and Knowledge Base