Feedback by UserVoice

Michael Bishop

My feedback

  1. 39 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Bishop supported this idea  · 
  2. 95 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Bishop supported this idea  · 
  3. 19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Bishop commented  · 

    I'd love to have this function.

    Michael Bishop supported this idea  · 
  4. 152 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Bishop supported this idea  · 
  5. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 1,287 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    290 comments  ·  Excel for the web » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Michael Bishop supported this idea  · 
  7. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 185 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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. 455 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    156 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. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    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