Feedback by UserVoice

Roy

My feedback

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

    We’ll send you updates on this idea

    You’ve provided feedback on the Excel Shared Workbook experience and we would like to know more about how you’ve used this feature and the value it provides. By taking this survey, you can help the Excel team better understand how to prioritize our Collaboration Experiences moving forward.

    Your input is greatly appreciated.
    Thanks

    https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR3M53G0xM8tHle2rOax4MqNUQ0lOWlM2OFRTTkJNRTVGQU1ZV0hDMTZYSy4u

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy commented  · 

    IFERROR() is not suitable to all situations. Besides, many times the error returned is not especially useful to a USER and so an error written with one's own users in mind, or, more generally, with one's subject material in mind vs. the very, very generalist and sanitized spreadsheet concept in general, could be very handy.

    Yes, Mr. B., I know, they should all be trained professionals to use Excel, not folks picking up a tool and caring only for its result, not for it itself...

    Gosh.

    Likely snb is inputting it twice because when IFERROR() does not suit, like, oh, I don't know, maybe when you want to give it a result for false, not just true or error, one must do the usual twice entered IF(), not IFERROR().

    And wrapping an IF() in IFERROR() isn't much better for most formulas.

    I like it: IF(true,false,error). I would love it to allow nested IF()'s in the error condition too so I could generate multiple homemade error results for multiple thought of or already encountered error causes.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy supported this idea  · 
  6. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy supported this idea  · 
  8. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy supported this idea  · 
    Roy commented  · 

    Too bad we can't wrap a portion of a formula with that and Excel then populates the "innards" as if they were a standalone CSE, then give us a few new formulas that let us select out one or more elements for further work.

    An example from another suggestion used ABS(). So, for instance, one might use =ABS(some-range) to get something, say {1,2,A,cat,5,6}, as that element's output into the rest of the formula. So many times now, that kind of input to the rest of the formula yields an error result.

    But =ARRAYFORMULA(ABS(some-range)) would make the internal array available to new functions like, say =PICK(), so one might now have

    =PICK(ARRAYFORMULA(ABS(some-range)),4) and the fourth element of that internal array ("cat") is selected from it and passed on to the rest of the formula as "cat" rather than "{cat}" so the rest of the formula can ALWAYS handle it, not just sometimes.

    Additionally, sometimes a function could be used in an "array sense" but is not programmed to do so. This function could force that. Now, if using one that way, you simply get an error, or it picks the first element of the relevant array of data. Just not programmed to think in array terms. So given a data range rather than a single cell or element, it defaults to the first cell or other element or simply fails. This could force it to operate on the entire array offered and produce whatever result from treating each element one after another. Nothing new to the function being wrapped, and if it still failed to produce sensible results, then so be it: error. But so many times...

  11. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
    Roy commented  · 

    I agree with Ken that negation is a useful thing and the issue is it taking priority as you describe. It should take place last.

    Then it would match how the rest of the world does things.

    For backward compatibility, perhaps it should add a setting for the spreadsheet of the sort that "grid lines off" is. First time opening any file without the setting populated, it would ask and populate the setting for the file.

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

    We’ll send you updates on this idea

    Roy commented  · 

    As to the translating formulas idea, you'd sure think a company that provides myriad different language versions would be able to easily provide a utility function that would take a formula in whatever version you work in, or obtain a spreadsheet from, and change out all that kind of thing for you.

    It's surprising really, that no one in programming language-land or IDE-land or even compiler-land has not written a standalone product that will work with an open spreadsheet and do precisely these things. End result, it places the work it produces in the cell you've selected. Done. Use your favorite provider as competition happens.

    And no need to wait for MS to do anything. (Sigh... )

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

    We’ll send you updates on this idea

    Roy commented  · 

    Yep, both this and the regular expressions would be nice!

    For this, F&R the "=" with, say, "MMM=", then F&R the first side of the expression, then F&R the second side, then finish by F&R-ing the "MMM=" back to "=".

    Talk about crude, eh? Be nice to click an option in F&R to hold off Excel's checking/calculating results until you exit the F&R box. then if it doesn't like the results, you'd probably agree and want to have it reject it all and let you start over clean... AFTER it shows you the resulting formula in the first cell so you can inspect for what you did wrong, then acknowledge it and start over at the first OR the second/third/fourth/etc. step.

    Roy supported this idea  · 
  14. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy supported this idea  · 
  17. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy supported this idea  · 
    Roy commented  · 

    A little more detail: if you give a date like 2-March-17 for the end date, one for which you completely"pass over" February, it DOES give 30 days for February, then adds 2 more for the time in March for a result of 32. So it is adding 30 for the 28 day month, then the 2 for the two days in March.

    So apparently it is not "kicking in" until you reach a date more than one month away from the start date. Then a date in February simply counts actual days until the date, rather than recognizing the user sees it as a different month and expects exactly 30.

    Hopefully MS can see the ease of fixing it now!

    In the meantime (which... might be forever...) one could force it to the end of the month with EOMONTH(), add 1, and calculate. So any time at all in February would yield the expected 30.

  19. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy shared this idea  · 
  20. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy supported this idea  · 
    Roy commented  · 

    The formula is just a sum of a sequence formula. So it is the number of items ("n" let's say) divided by 2 and that multiplied by the sum of the first number in the sequence ("1" for triangular numbers) and the last one (the number of items ("n" as I called it above) or better name: the number you want the triangular number for (still "n")):

    Triangular number = (n/2) * (1 + n)

    So in Excel, let's say you put the number you want a triangular number for into cell A1. Your formular would then be:

    =( A1 / 2 ) * ( 1 + A1)

    Hope that helps. My bet is they won't ever add this one because it would be a fairly rarely useful function, fairly specialized in its uses.

    However, if they added a broader function, maybe called SEQUENCE() or SUMSEQUENCE(), some variation that, it might be useful to a lot more purposes and would completely fit your needs as well.

    It could have three arguments (inputs): the ending number, the sequence's starting number (so the sequence could begin at any old number instead of at "1" — broader appeal, more chance of it happening), and the difference between each number in the sequence (so you could sum up sequences like 3,6,9,12... not just 3,4,5,6 type sequences). Broader appeal. And it could be set so if the 2nd and 3rd arguments are not there, it starts at "1" and goes up by "1" so for your use, you'd just have to give it the number you want a triangular number for.

    The broader the appeal, the more likely you might be to get it! Good luck!

Feedback and Knowledge Base