Feedback by UserVoice

 

Michael Bishop

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Create function Unique(array) extracting unique values from an array

    39 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    11 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Bishop supported this idea  · 

  2. Add a CountDistinct (unique, etc.) function

    95 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    9 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Bishop supported this idea  · 

  3. Add a MATCHIFS formula

    17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    6 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Bishop commented  · 

    I'd love to have this function.

    Michael Bishop supported this idea  · 

  4. Remove the pointless message “There's a problem with the clipboard, but you can still paste your content within this workbook."

    133 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    97 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Bishop supported this idea  · 

  5. Sheet-side Split function

    12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    8 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Bishop commented  · 

    I'd love to have a TextSplit function in Excel. I'd use it heavily, and my Excel files would be much cleaner.

    Michael Bishop supported this idea  · 

  6. Links between spreadsheets in Excel Online

    1,125 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    245 comments  ·  Excel for the web » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    planned  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for all of your comments and votes supporting this suggestion. We are now in the planning stages to support creation and refresh of external links for workbooks opened in Excel Online.

    Thanks – Micah M [MS Excel]

    Michael Bishop supported this idea  · 

  7. Structured reference for different row in a table column

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    8 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Bishop commented  · 

    Kenneth, I'm sorry for my weak reply.

    Here's the most common scenario where this new structured-reference option would help me:

    I have one table with formulas that reference one of two other tables depending on the situation (If statement). Let's say I'm referencing table columns with headers "1:00" to "12:00" and the referencing table is populating columns with these same headers. I could directly reference the headers:

    =If(Condition1=True,Index(TableA[1:00],[@Row]),Index(TableB[1:00],[@Row]))

    But I'd prefer to copy the same formula across all columns. If the "1:00" column starts in a different place in TableA and TableB, I'd need to use the Match function to reference the correct column. Instead of cluttering every formula with Match (and slowing down calculations), I put the Match formula in a helper row at the bottom of the table. My formula looks like:

    =If(Condition1=True,Index(TableA,[@Row],A$13),Index(TableB,[@Row],A$13))

    With my suggested feature, it'd be something more readable like:

    =If(Condition1=True,Index(TableA,[@Row],[#Column]),Index(TableB,[@Row],[#Column]))

    Does this make sense?

    Michael Bishop commented  · 

    With all due respect, the formulas aren't relevant.

    Michael Bishop commented  · 

    Thanks, please see this screenshot: http://screencast.com/t/c1srvPnC.

    The formulas in this table reference the last row to see if the table results are Not Applicable (NA). This helps us avoid redundant checks in each formula and keeps the formulas smaller / more readable. We have these supporting rows in tables throughout the file.

    Michael Bishop commented  · 

    Thanks for your reply. I'm looking for something very simple here. This is a feature request. Here's a screenshot: http://screencast.com/t/oWVe147T

    Michael Bishop shared this idea  · 

  8. Two new =if's

    176 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    11 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Bishop commented  · 

    I hope you're still considering the IfZero function. I know it doesn't have that many votes, but I'd use this function every hour of my spreadsheet work and would give it all the votes in the world if I could. Hopefully you agree that it's a compelling function.

    Michael Bishop commented  · 

    I'd also really appreciate introduction of the IfZero function. It'd help me keep a cleaner and tighter spreadsheet.

    I like Kenneth's last workaround except that it makes it harder to identify errors.

    Michael Bishop supported this idea  · 

  9. Ability to open Excel Online in Edit mode by default or link to edit mode

    447 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    155 comments  ·  Excel for the web » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Tamar Tzruya responded

    Thanks for your feedback! We’re reviewing your suggestion. I would like to clarify: If sharing through SP the URL parameters are hashed. When a user edit an Excel file and copy the URL for sharing over email the user can choose to change the action to edit.
    Remember, the more votes a suggestion gets, the more likely it is that we’ll do it.

    Tamar [MSFT]

    Michael Bishop supported this idea  · 

  10. Preserve text boxes in Excel Online

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for the web » Graphics  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Bishop shared this idea  · 

Feedback and Knowledge Base

(thinking…)