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. Fix =Z1 when Z1 = "" should return "" not 0, No work around w/ Dynamic Arrays

    There has been a longstanding issue as follows. When referencing a cell (e.g. formula in cell A1 is "=Z1") and Z1 is blank/"" then the value returned in A1 is 0 (not blank/"" as expected). The work around for this has always been to change the formula to =Z1&"".

    The problem is now with Dynamic arrays this is not possible. Create a table with 3 columns, first 2 columns are a text values and 3rd column is a date or numeric. The write a dynamic array function =FILTER(Table1,Column2<>"Y"). The spilled array will return a 0 in column 1 or 2…

    1 vote
    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 →
  2. concatifs

    Make a function conditional concat
    just like sumifs and with a separater

    1 vote
    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. XLOOKUP should allow one range to be vertical and one horizontal

    XLOOKUP is a great alternative to INDEX / MATCH, but it requires both ranges to have the same orientation (to either both be horizontal or both be vertical). With INDEX / MATCH the ranges used as arguments for the two functions can each be either horizontal or vertical. SInce XLOOKUP is just working with two ranges they should be able to have any orientation as long as they are the same size.

    1 vote
    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 →
  4. Add a Split dynamic array function

    Add a dynamic array function to split apart a delimited range. See attached file for an example.

    1 vote
    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 →
  5. New SUBSTRING function

    Excel should have a function called SUBSTRING which accepts two parameters: Cell where to look and a Substring. If the substring is found, then return TRUE.

    1 vote
    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 →
  6. 1 vote
    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. 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 user-defined 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…

    40 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 →
  8. please make this appication to find he value of squaeroot of (-1) combined with equation to find the value of equation

    please make this appication to find he value of squaeroot of (-1) combined with equation to find the value of equation

    1 vote
    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. XLOOKUP to return not found value

    When we are looking up the value from the list, XLOOKUP to have the ability to return the values not found from the search list, currently user filter the #NA value and paste the data

    1 vote
    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 →
  10. Excel Dynamic Array Formulas

    Excel Dynamic Array Formulas should include optional (Sum - Count - Average) for the totals

    1 vote
    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 →
  11. Be cool to be able to set a default value in a data validation list that shows if no adjustment is chosen

    When selecting the data validation dropdown list it would be great if you could preset the field to show a default value.

    For example, a list of currency alternatives, and a default value of GBP. How can I do that with the current program?

    1 vote
    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 →
  12. Improve Spill Error detection

    We use Multiple spreadsheets to build an asset register. Prior to last update, we were able to simply change sheets on an open cell and select to "mimic" the data in a cell.
    With the introduction (or fine-tuning) of a the Spill formulas, now when you select the cell to "mimic", a Spill Error is given unless you know to add in the "@" before the name of the cell.
    For basic users, with limited computer/MS literacy, they may not be aware of the addition needed for the formula that previously worked to work now and this change may cause…

    1 vote
    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 →
  13. Payments for Good Sugestions

    Does Microsoft pay its users or award prizes for forwarding good suggestions to improve on its usability. You are a billion dollar company and it is only fare that you do so. Please reply.

    Regards

    1 vote
    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. 1 vote
    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 →
  15. 2 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 →
  16. Append Arrays using a UNION function or {}, and Ability to use Dynamic Arrays in Tables

    I would like the ability to create a union of arrays, whether it be a function or typing in a union. In the example below, I need data from columns 1 and 3 from 3 different tables:

    Tables:
    data1 (2 rows, 3 cols), data2 (6 rows, 3 cols), data3 (8 rows, 3 cols)

    {data1[col1],data1[col3]; data2[col1],data2[col3]; data3[col1], data3[col3]}

    This would create a list of 16 rows in total from column 1 from all tables. (use commas to add column data, semicolons to add rows)

    It would be a useful feature if there were matching sets of data for that were divided…

    1 vote
    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 →
  17. Add a GPS functions and formulas

    1 Compute the distance between to GPS points

    2) Compute the shortest route between to points from Bing map. An application would be the route travelled for a rent a bicycle program.
    3 ) Does a GPS point fall within a defined radius of a GPS point, eg how many slippery sidewalk calls came from within one kilometer of City Hall
    4 ) Find GPS point from a street address

    1 vote
    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 →
  18. Evaluate Formulas based on spilled array need to show evaluation for each row (not just formula row)

    If you enter a dynamic array formula in cell A1 (which spills the results) and then you write a formula in cell B1 that is based on A1# that results set will also spill.

    However the evaluate formula function will never evaluate for any row in the spilled array in column B except B1. Put another way if you go to cell B2 and click Evaluate Formula and step through it the formula that is evaluated is the formula in cell B1. This makes it impossible to debug formulas based on spilled arrays.

    I really think this is a bug…

    2 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 →
  19. 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.

    8 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 →
  20. Range Filter

    One of the most useful functions in excel are the *IFS; like countifs, sumifs,...etc.

    However, it would be great to have this syntax in all functions by dedicating a separate function that applies criteria on different ranges and returns a range that satisfies all of these conditions.

    Example:-

    Currently we have to do this :

    =Median(if(Range1=Criteria1,if(Range2<Criteria2,if(Range3<>0,Range4,))))

    Alternatively, we can have a function that looks like this:

    =Median(RangeFilter(Range4,Range1,Criteria1,Range2,"<"Criteria2, Range3,<>0))

    This syntax is copied from SUMIFS but it will allow us to apply it to any function.

    1 vote
    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 39 40
  • Don't see your idea?

Feedback and Knowledge Base