Feedback by UserVoice

Sergei Baklan

My feedback

  1. 224 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 suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    I voted since that's better than nothing. But I definitely would like to have an option to switch on/switch off such expanding. In general that's much better to have separate formatter or Advance Editor, more they are integrated into Excel the better.

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Fabio, I guess practically all of us use such formula, but SPLIT() will be much more suitable

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    like =SPLIT(<text>,<delimiter>,[<splitby>],[<splitto>)
    where
    splitby
    -1 by first delimiter
    0 by each delimiter (default)
    1 by right delimiter

    splitto
    TRUE to columns (default)
    FALSE to rows

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

    We’ll send you updates on this idea

    Sergei Baklan supported this idea  · 
    An error occurred while saving the comment
  4. 73 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    It allows if you use From File->From Sharepoint Folder connector and use your OneDrive URL

  7. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Sergei Baklan commented  · 

    That is floating point error https://docs.microsoft.com/en-us/office/troubleshoot/excel/floating-point-arithmetic-inaccurate-result which is not specifically Excel issue.

  8. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    That's not a bug, that's interpretation. If you use QUARTILE.EXC() https://support.office.com/en-us/article/quartile-exc-function-5a355b7a-840b-4a01-b0f1-f538c2864cad it returns result exactly the same as your manual calculations. And it's differ from what QUARTILE.INC() and QUARTILE() return.

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

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Sergei Baklan supported 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

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Robert, was not able to reproduce. I'm on 1912.1235.20012, English SKU

  11. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Was not able to repeat - version 1912, English SKU

  12. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Afraid that never will be corrected - end of 2010 support in next year, and in later versions the spelling is correct.

  13. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 
  14. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    That's not Excel, that's Windows. Go to your regional setting (Win+R and type 'control international'), Additional settings, Date, and here you may change the range for two-digits year interpretation. By default it is between 1930 and 2029.

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

    We’ll send you updates on this idea

    Sergei Baklan supported this idea  · 
  16. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Blank cell is considered as zero if you compare the numbers. Dates in Excel are actually sequential integers where 1 is equal to 01 January 1900. Thus any blank cell is less than any date.

  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    So far that's only for Office Insiders Fast, are you on this channel?

  18. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Kenneth, you may add based on data model both PivotTable and PivotChart from Excel sheet ribbon. Just in Insert->PivotTable pop-up window select "Use this workbook's Data Model"

  19. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    That's like =INDEX(A:A,COUNTA(A:A))-A1

  20. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    Insider Fast?

← Previous 1 3 4 5 6

Feedback and Knowledge Base