Feedback by UserVoice

Kevin Osborn

My feedback

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

  3. 41 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. 55 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  · 
  5. 2 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  · 
  6. 138 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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  · 
  7. 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  · 
  8. 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 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  · 
  9. 142 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. 1,149 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  · 
  11. 53 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. 53 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  · 
  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. 269 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. 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  · 
  16. 551 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion E Bow. Thanks for taking the time to tell us about changes you’d like to see – we’re listening. We’ll take a look at this one. As always, folks should keep voting for the things they like the most – we’ll generally be prioritizing things according to the number of votes they get.

    Cheers,
    John [MS XL]

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

    We’ll send you updates on this idea

    Hi everyone,
    Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

    One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

    We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

    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.

  18. 141 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. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn commented  · 

    I don't have an issue w/ your suggestion but I think the real problem is the inability to find broken links (in cells, names, conditional formatting, etc.). If the ability to find all broken links existed then I'm not sure there is a need to paste the formula.

  20. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn commented  · 

    Totally agree. Breaking links is not a solution and there is no way to find broken links that looks in conditional formatting, ranges, etc.

    Kevin Osborn supported this idea  · 

Feedback and Knowledge Base