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. Integrate units into cells for display and mathematical operations

    Allow numbers to be displayed with text (without using the concatenate), while also being able still use the numbers/text for equations. Then units can be displayed (e.g.20 mm) and referenced to be operated on via another cell (e.g. 20mm*2+5 = 205mm)

    ---------------Keep reading if want more Details/explanation---------------
    Minimum way to implement would be to provide function to ignore all text for calculations (de-concatenate?) but then add it back in at the end (re-concatenate)...all in one function. This would be the quick and dirty method to get the low hanging fruit.

    Super slick way to implement would be to go a…

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

    We’ll send you updates on this idea

    10 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Root Mean Square Error (RMSE)

    Please add RMSE formula to statistical function library.

    3 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 →
  3. worksheet function for returning a field inside a delimited lists

    I’d like to have a function available that returns a specified field within a delimited list. I would pass the list, a delimiter and a field number as arguments to the function and it should return the value in that field.

    For instance with the pipe separated list ”TEST1|TEST2|TEST3|TEST4| TEST5|||||||TEST|” in A1.
    I’d like to use something like GetFieldInDelimitedList(A1;"|";5) and have it return “TEST5”.

    Any equivalent formula will requires quite a lot of nested functions e.g.:
    =MID(A1,FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1,FIND("([])",SUBSTITUTE(A1,"|","([])",5))-(FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1))

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

    We’ll send you updates on this idea

    5 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. string function which returns the number of occurences of a sub-string

    I regularly have comma separated lists, and would like to know how many values there are in the string. Currently do that in VBA, but it would be nice if there was a function for that. E.g.:
    A1 = "abc, def, pqr, xyz"
    B1 = PARAMS(A1,[optionally]",") optionally so that you can do ; or others as well

    5 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 →
  5. Improve the Match Function

    Make the Binary Options of Match to work on Unsorted Data
    Provide an Optional Parameter for Search Instance
    =MATCH(What to Search,Where to Search,[Match Type],[Match Instance])

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

    We’ll send you updates on this idea

    6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Create a function ISDATE(Data)

    Please, create a function ISDATE() to test if the contain of a cell is a date or not. This function exist in VBA but not in the Excel function. That's weird

    11 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 →
  7. To create a new function to Convert figures into letters

    A new function in order to convert a figure for ex. 2 into two, and more difficult as 1.350, 1.698.367 etc.

    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 →
  8. New maths & stats functions

    Like MAXIF, MINIF and SUMPRODUCT that works on Row x Column (currently need to rely on MMULT even for 1 dimensional arrays or use TRANSPOSE)

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

    We’ll send you updates on this idea

    5 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. 0 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 →
1 2 34 35 36 38 Next →
  • Don't see your idea?

Feedback and Knowledge Base