Feedback by UserVoice

Kevin Osborn

My feedback

  1. 173 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
    Kevin Osborn commented  · 

    This suggestion is accepting votes so I encourage everyone to go vote here and also add you comments to give more support to improving CF.

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8778211-improve-the-conditional-formatting-manager?page=3&per_page=20

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    Conditional formatting is arguably the most "left behind" area in Excel.
    - Make conditional formatting rules editor window sizable >> Yes
    - Make live preview >> Yes
    - Make formulas work like real formulas (auto complete, error checking, allow named ranges and structured reference, make them follow normal volatility rules based on the formulas used) >> Yes
    - Additions/Subtractions/Moving ranges should not fragment the CF ranges >> Yes

    Kevin Osborn supported this idea  · 
  2. 123 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
    Kevin Osborn commented  · 

    An improvement to the suggestion would be to list the cells where the #REF would occur similar to Find All so that the user can click on the list and change the formula that would result in #REF and then come back to delete the cell or make the changes that would cause the #REF.

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

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  4. 18 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
    Kevin Osborn commented  · 

    Actually if MS fixed (improved) dynamic arrays such that it can be placed inside a table the totals would be there via the table total row. Unfortunately at this time since a dynamic array cannot exist inside a table we have this problem as well as losing the ability to used structured reference for dynamic arrays (which are essentially a table).

  5. 262 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
    Kevin Osborn commented  · 

    I understand where you are going with this but I'm not going to vote it up. IMO a better solution is to allow 1 dynamic array function inside a table. Not only will this address your issue with sum/count/avg for columns because tables can have a "total" row but it will also fix the deficiency in dynamic arrays whereby structured/table reference cannot be used to reference a column in a dynamic array so the developer is forced to revert back to column numbers. Similarly instead of having sum, count, average rows I'd rather see a "Row Total" added to tables (similar to column totals).

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

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  7. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn shared this idea  · 
  8. 160 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
    Kevin Osborn commented  · 

    I think there may be an issue with the phrasing of this request. I just got access to dynamic array functions and the problem is this.

    Before dynamic arrays we all created formulas to populate a column within a table with a list of data (many times unique) and lets call this ColA within Table1. Then we would create other columns via formulas based on [ColA] so [ColC] = [@ColA] * [@ColB] for a simple example. Structured reference made this awesome when tables have many columns. Then elsewhere in the spreadsheet we could use structured reference to look up values from Table1 (e.g. =SUMIFS(Table1[ColC],Table1[ColD]&"<>") ).

    Now with array formulas we can create a unique list A2 = SORT(UNIQUE(Table2[ColX])) and it will spill down column A. Then other columns (e.g. column B) we can create a formula B2 = IF(A2# = "Red",1,0) and this too will spill. So we have kind of created a 2 dimensional structure (i.e. a table) but we have no ability inside nor outside this "array formula created 2 dimensional structure" to use structure reference (i.e. column name) so we have to go back to remembering columns by column letter and we lose autocomplete that goes along with structured reference.

    So kudos for array formulas but what it looks like I will be doing until this is addressed is creating a helper column outside my table with the key information (i.e. the SORT(UNIQUE(***)) ) and then inside ColA of Table1 is the formula = Z2, = Z3, =Z4 etc.

    Give this some serious thought Microsoft. I realize you'll need to limit a table to 1 dynamic array formula per table or the dynamic arrays could conflict one another in the spill range. Without this you have seriously limited the usefulness of dynamic arrays.

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

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  10. 3 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
    Kevin Osborn commented  · 

    Very interesting idea. Thanks for posting. It would need to be an optional parameter of course. And in some cases it would eliminate the need to add conditional formatting. I like it!

    Kevin Osborn supported this idea  · 
  11. 239 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  12. 1,426 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Kevin Osborn supported this idea  · 
  13. 61 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  14. 62 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  15. 110 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  16. 568 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    Kevin Osborn supported this idea  · 
  17. 339 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi all,

    Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Thanks,
    Guy Hunkin
    Excel Program Manager

    Kevin Osborn supported this idea  · 
  18. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  19. 616 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  20. 1,112 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Huge progress update toward historical data! We have released our preview of the StockHistory function! https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8

    However, this is only available to our Beta Channel at the moment, so when it is rolled out to General Availability, I will be sure to update the status to completed.

    If you are able to use the feature in preview and have feedback, please send-a-frown for us to review.

    —Kaycee Reineke
    Excel PM

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    James (et. al.) - There is one item not listed in the article on how to use the feature that is critical. For those who still can't see the Stock Symbol or Geographic data types on the ribbon you MUST be signed into your Microsoft account for these to appear. I couldn't get them to appear until I signed into my Microsoft account.

    So 2 pieces of feedback. Ultimately the Ribbon should show these choices even if the user is not signed in. That doesn't mean they should function (maybe they are grayed out) until the user signs in w/ flyover help identifying this. But certainly you should update the article to identify to the reader that the icons won't appear if the user is not signed in.

Feedback and Knowledge Base