Feedback by UserVoice

Sergei Baklan

My feedback

  1. 8 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  · 
  2. 6 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  · 
  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Sergei Baklan commented  · 

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

  4. 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 →
    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.

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

    We’ll send you updates on this idea

    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.

  6. 2 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  · 
  7. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Sergei Baklan commented  · 

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

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

    We’ll send you updates on this idea

    Sergei Baklan commented  · 

    Was not able to repeat - version 1912, English SKU

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

    We’ll send you updates on this idea

    Sergei Baklan commented  · 

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

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

    We’ll send you updates on this idea

    Sergei Baklan commented  · 
  11. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  12. 22 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  · 
  13. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

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

    We’ll send you updates on this idea

    Sergei Baklan commented  · 

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

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

    We’ll send you updates on this idea

    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"

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

    We’ll send you updates on this idea

    Sergei Baklan commented  · 

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

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

    We’ll send you updates on this idea

    Sergei Baklan commented  · 

    Insider Fast?

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

    We’ll send you updates on this idea

    Sergei Baklan commented  · 

    That is XMATCH

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

    We’ll send you updates on this idea

    Sergei Baklan commented  · 

    Yes, negation means (-1)* and subtraction means minus. If use two different characters for negation and subtraction everything will be logical.

    Sergei Baklan commented  · 
    Sergei Baklan supported this idea  · 
    Sergei Baklan commented  · 

    Hi Martin,

    That's a great question why people who designed Excel more than 30 years ago decided what negation is to be performed before exponentiation. But that's what they did, the order of Excel operations is described here https://support.office.com/en-gb/article/the-order-in-which-excel-performs-operations-in-formulas-28eaf0d7-7058-4eff-a8ea-0a835fafadb8. By the way, exactly the same logic is used for Google Sheets, it also returns +36 if type =-6^2.

    That is almost 20-years old but quite interesting discussions about the subject on Math Forum https://support.office.com/en-gb/article/the-order-in-which-excel-performs-operations-in-formulas-28eaf0d7-7058-4eff-a8ea-0a835fafadb8.

    I'm very suspicious what that will be ever changed. Same with year 1900 - someone who designed Excel decided what that is the leap year, which is not. That issue is also known for about 30 years, but it never will be corrected due to compatibility. There are only support articles which explain what we have what we have and have to live with that.

  20. 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 commented  · 

    Hi Gordon - that's a trigger, click "Show all notes" again to hide them

← Previous 1 3 4 5 6

Feedback and Knowledge Base