Feedback by UserVoice

miko

My feedback

  1. 174 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko commented  · 

    surely it's a better idea to implement this:

    IFX(LongFormula, Condition1, Value if True, Condition2, Value if True, ... ConditionN, Value if True)

    but whatever's faster to implement to be honest!

    miko commented  · 

    Everyone who voted for this should also vote for the IFX() generalised formula, so that it covers IFZERO(), IFBLANK(), IFNULL(), etc
    It would also cover IF[anything], and thus entirely remove the need for doubling up the [long formula] bit.
    Fingers crossed!

    miko supported this idea  · 
  2. 2,030 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!

    Eric Patterson (Program Manager – MSFT)

    miko supported this idea  · 
  3. 40 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko supported this idea  · 
  4. 30 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko supported this idea  · 
  5. 44 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko supported this idea  · 
  6. 11 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko commented  · 

    It also removes any spaces I have inserted to make parsing the formula easier if I accept changes - which is not only annoying, but it also makes it harder to spotlight the changes with eagle eyes on the formula bar as so much shifts positions...

    I don't get why this isn't getting more votes. Is it just us 3 that get bugged by this?

    miko commented  · 

    Same here; it can take ages to locate! And it would surely be a very quick upgrade to implement!

    miko supported this idea  · 
  7. 5 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko commented  · 

    alt +253 gives you superscripted 2 (e.g. m²)
    alt +252 gives you superscripted 3 (e.g. m³)
    alt +248 gives you superscripted 0 (e.g. 90°)

  8. 3 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko commented  · 

    yes yes yes. Good plan!

    as an 'as well as' though,

    coz i love conditional formatting (if it could only be applied to named ranges and stop infecting whole documents and making things crash)

    miko supported this idea  · 
  9. 654 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

    miko commented  · 

    OK so even if they don't fix the root problem, at least make it easier to deal with, which should be an easy fix :

    -Allow us to resize the pop-up window
    -Allow us to reorder rules viewed by format applied (without charging precedence level) so we can see all the rules that USED to be one.
    -And maybe even a 'merge with rule below' button, or a 'convert this sprawl of individual cells back into the most simply expressed range(s)' button
    -(And a 'copy rule' button shouldn't hurt whilst doing that, though it's a separate problem)

    miko commented  · 

    i would also add the ability to search for, or the automatic highlighting of all external references in conditional formatting, as they are otherwise hard to find & manage, especially when after some editting, a very few conditional formatting rules quickly become huge list of the same rules applied to different ranges...

  10. 5 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko commented  · 

    This is essential. Why is this not got more votes?
    Conditional formatting is AMAZING, and surely there's no need for it to be more volatile than the formulae using in calculating them...

    PLEASE PLEASE do this.

    I'm sure that plenty of people who don't understand volatility (but suffer from it) would vote this up if they did understand it...

    miko supported this idea  · 
  11. 91 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko commented  · 

    ********!
    Trace dependants SHOULD be so useful, but this makes it next top useless when tracing across worksheets...

    miko supported this idea  · 
  12. 19 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko 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

    miko commented  · 

    that's uncanny. I just literally had the same idea, with same names and same variables in same order.
    or maybe it's not uncanny. It's just a very logical upgrade.

    miko supported this idea  · 
  14. 5 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko supported this idea  · 
  15. 19 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Interesting suggestion Jon, thanks for posting it. There’s some other suggestions around blank/null, so we’ll be taking a look at the space in general, and making particularly sure that we consider related functions that get a lot of votes. As always, the more votes something gets the more chance that a specific request gets in the execution pipe sooner. So I just want to encourage folks to keep voting for the ideas they like best!

    Cheers,
    John [MS XL]

    miko supported this idea  · 
  16. 7 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko supported this idea  · 
    miko commented  · 

    Thanks for info, but really we shouldn't need add-ins to do this.
    How about adfding it to the available format in the TEXT() formula

    e.g.
    =TEXT(A1,"#th")

    if A1 = 1 returns "1st"
    if A1 = 11 returns "11th"

  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko shared this idea  · 
  18. 4 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko supported this idea  · 
  19. 2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko supported this idea  · 
  20. 1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    miko shared this idea  · 
← Previous 1

Feedback and Knowledge Base