Michael Bishop
My feedback
-
39 votes11 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Michael Bishop supported this idea ·
-
95 votes9 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Michael Bishop supported this idea ·
-
19 votes7 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Michael Bishop supported this idea ·
-
152 votes100 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Michael Bishop supported this idea ·
-
13 votes8 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 ·
-
1,287 votes
Hello,
Thank you for your continued feedback and responses. I am excited to let you know that the work for External Links for Excel on the web has started.
David
Microsoft Excel TeamMichael Bishop supported this idea ·
-
2 votes8 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 ·
-
185 votes11 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion figboot. As always, we’ll prioritize this according to the number of votes it gets, so please be sure to vote it up if you want to see it done sooner.
Thanks
John [MS XL]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 ·
-
455 votes
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 ·
-
4 votes
Michael Bishop shared this idea ·
I'd love to have this function.