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

    An error occurred while saving the comment
    Sergei Baklan commented  · 

    It's added, at least for Beta

  2. 279 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. 2 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 the difference between subscription and on time purchase models, Microsoft clearly explains that in support documentation. Feature update for one-time-purchase will be for next version, Excel 2022 or so.

  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 →
    An error occurred while saving the comment
    Sergei Baklan commented  · 

    1) Best way to contact, but without immediate feedback, is to Send a Frown within Excel, Microsoft monitors them.
    2) IMPRODUCT, as well as other IM..() functions for complex numbers, return texts. SUM() ignores all texts, thus result is zero. You may use IMSUM(), but why don't you use PRODUCT(), SUMPRODUCT() and/or SUM()?

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

    As mentioned XLOOKUP() shall work, but INDEX/MATCH is always an option.

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

    I hope it's coming, but yes, PQ for Excel is behind the PQ Online, PQ for Power BI Desktop and other branches. Not considering Windows and Mac significant difference.

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

    Josh, it's better to avoid merging and use Center Across Selection instead. Yes, shortcut for it will be usefull.

  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  · 

    Hope native function it's coming. With introduction of LABMDA you may create your own one, or use FITLTERXML() as workaround.

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

    Why SAVE a COPY doesn't work?

  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  · 

    IMHO, it works - if you apply CF to entire table/column it will be applied to newly added rows

  13. 99 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  · 
  14. 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  · 

    Yes, for 365. Don't remember on which channels.

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

    Notes still exist, you may use Comments or may use Notes. Check on right click menu (New Comment; New Note) or section under Review tab on ribbon.

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

    Nick, didn't catch, do you mean something like =SUM(Table1[[#Totals],[A]:[Z]]) ?

  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  · 

    I believe it won't be in 2019, perhaps in 2022 or how it will be named.

  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  · 

    Or INDEX/MATCH, VLOOKUP with MATCH if XLOOKUP() is not available. Like if you use Tables you may not care about range expansion, otherwise you shall use dynamic ranges. Here you also shall care about dynamic column position.

  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  · 

    IMHO, different phone number formats is the main issue which prevents to create universal one with leading zeroes. Otherwise that's not number formatting, that's converting to text.

    If work with numbers you may use your own custom number format for phone numbers like +0(000)0000 000, depends on how many digits it shall be in it. That could Ctrl+1 plus Format Painter or better to create cell style.

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

    If creating PivotTable you add data to data model Excel automatically renames Date to Date 1 in data model, thus in PivotTable, as well. No actions are required.

    Another story if you rename Date to DATE. In this case you shall additionally rename Date to DATE in data model manually.

← Previous 1 3 4 5 6 7 8

Feedback and Knowledge Base