Feedback by UserVoice

Charley Kyd

My feedback

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Good news! We have released a few fixes to Insiders to address this issue. If you are on Insiders, please let us know if the fix has worked for you.

    The fixes should be in build 11809.10000 and onwards.

    -Joe McDaid [Excel Team]

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

    We’ll send you updates on this idea

    Charley Kyd shared this idea  · 
  4. 174 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charley Kyd supported this idea  · 
  5. 1,014 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!

    John, Excel

    Charley Kyd supported this idea  · 
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charley Kyd shared this idea  · 
  7. 29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charley Kyd supported this idea  · 
    Charley Kyd commented  · 

    Negative date-time values currently have no meaning. It would be easy to use those values to cover ALL dates prior to 1900. With the right approach, astronomers, geologists, paleontologists, historians, genealogists, and so on, could use dates prior to 1900. To do so, however, we’d lose the ability to work with the time of day prior to 1900.

    The scaling would take some thought to define. The Gregorian dates could go back, perhaps, to Monday, Jan 1, 4713 B.C...the beginning of the Julian calendar. Further back, there’d be a span where only years were tracked. And then centuries, and so on.

    This adjusted scaling makes sense, because, for example, the K-T event happened about 65.5 million years ago. But no one will ever be able to say (or want to) that it happened on Tuesday, May 16, 65487 BC at 2:49 am, GMT.

    And also, along the way, there's be a function that could convert between Gregorian and Julian dates.

  8. 69 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charley Kyd shared this idea  · 
  9. 1 vote
    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 Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd shared this idea  · 
  10. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charley Kyd shared this idea  · 
  11. 18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charley Kyd commented  · 

    I agree! If we want to return text from a Table, MATCHIFS would provide an easy way to do it.

    I know, there are workarounds. But they shouldn't be needed. Instead, we need MATCHIFS.

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

    We’ll send you updates on this idea

    Thanks for the feedback. This is an interesting idea. We’ll consider this in our future planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

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

    We’ll send you updates on this idea

    Charley Kyd commented  · 

    We need two functions that return arrays: UNIQUE(reference or array) and SORT(reference or array)

    Together they could return a unique, sorted lists from a Table column for use with dropdown list boxes.

    Yes, we can do this with complicated array formulas. But those formulas calculate VERY slowly with Tables of hundreds of thousands of rows. On the other hand, UNIQUE() and SORT() worksheet functions could be optimized to return their data quickly.

  14. 62 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    This is great feedback. We are looking into the details of this. Please continue to vote on feature ideas which will increase their likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

    Charley Kyd commented  · 

    This should be a setting that affects the upper and lower bounds of the chart. That way, as the data changes, the bounds adjust automatically to apply the zoom setting.

  15. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charley Kyd shared this idea  · 
  16. 25 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Interesting idea. Thanks for the feedback. We’ll consider this in our future planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Charley Kyd commented  · 

    And also, enhance that feature so we can save the image easily in VBA!!!

  17. 65 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charley Kyd commented  · 

    The easiest way to implement this would be to introduce a BLANK() worksheet function that would cause Excel to treat the cell as blank in charts.

  18. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charley Kyd shared this idea  · 

Feedback and Knowledge Base