Feedback by UserVoice

Sergei Baklan

My feedback

  1. 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  · 

    Roy, as a comment, implicit intersection is not removed at all in modern Excel, it only used in a bit another form as =@INDEX(data!$A$4:$B$9,0,2). Zero says INDEX to return entire column, second in this case, and @ returns implicit intersection for that column, or, as in structured references, return the value for the same row. Result will be exactly the same.

  2. 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  · 

    Please check this support page https://support.office.com/en-us/article/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd

    If you set Row_num or Column_num to 0 (zero), INDEX returns the array of values for the entire column or row, respectively.

  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  · 

    That's a feature, not bug. "?" and "*" are wildcards in find and replace. To replace only question mark use "~?" in Find what: bar.

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

  5. 4 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  · 

    Such requests are at least 15 years old...

    Sergei Baklan supported this idea  · 
  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 commented  · 

    As some workaround select sheet(s) to save->right click menu Move or Copy->check Save a copy->to book: new book->save as file now

  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  · 

    You use formula not correctly, please read help more carefully

  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  · 

    Hi Robert - I'm on UK locale and all English months are recognized correctly for your example. I guess your are in German locale and Excel recognizes only months which have same spelling in both languages.

  9. 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  · 

    You may simplify a bit manual swapping - keep Shift pressed and drag selected cell by its border

  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  · 

    By the way, it's not necessary to insert new column, cut another, paste on new location, etc.

    Select column, press Shift and hold it, position the mouse on any vertical border of the selected column and drag it onto desired position.

    Same for rows.

  11. 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  · 

    Could you please clarify what exactly doesn't work? Millions of people use it

  12. 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  · 

    Hi Steve,

    With structured references it also works like
    =COUNTIF(OFFSET(tblOne[[#Headers],[Opponent]],1,0):[@Opponent],[@Opponent])

    Sergei Baklan commented  · 

    In general COUNTIF($A$1:A1,A1) is Ordinla(A1:A4,A1), etc.... COUNTIF($A$1:A4,A4)

  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  · 

    Hi Jim,

    Instead of built-in function you may write your own to pick-up the object from Excel file with siteURL, filename and objectName parameters, that's not necessary to repeat all steps every time.

    I guess the issue here is since Sharepoint Online operates with files IDs, not with file names directly, and we have to map somehow one on another.

    Anyway, glad to help.

    Sergei Baklan commented  · 

    Jim, Power Query works fine with Excel files on Sharepoint Online sites. You may google for technical details, in general the query is like

    Sharepoint.Files(<root site URL>)
    Filtrer file by name
    Get binary contend
    Get object from file (table or sheet)

  14. 26 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  · 
  15. 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  · 

    It's not as simply storing the number, that's the combination of infinite binary representation and accumulated rounding error. Anyway, that discussion from computer science starts and not only related to Excel. As workaround you may use https://support.office.com/en-us/article/set-rounding-precision-e5d707e3-07a8-4df2-810c-218c531eb06a

    Sergei Baklan commented  · 

    David, that's not a bug, that's nature of floating point calculations. You may check here https://www.microsoft.com/en-us/microsoft-365/blog/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers/ and in other places.

  16. 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  · 

    I guess since =FIND("@",A4) returns an error (instead of FALSE) if no @ in 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

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Sergei Baklan commented  · 

    You may check file size in Properties (File->Info), and clicking on drop-down near Properties title you may see more in Advanced properties

  18. 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  · 
  19. 1,553 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  · 
  20. 140 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  · 
← Previous 1 3 4 5 6 7

Feedback and Knowledge Base