Feedback by UserVoice

Peter Bartholomew

My feedback

  1. 40 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Bartholomew supported this idea  · 
    Peter Bartholomew commented  · 

    Agreed. Full screen would be good.
    With large arrays it is probable sufficient to see the 'corner' elements once you have stepped out from the array calculation itself.

  2. 2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Bartholomew commented  · 

    Now as I have settled in to using dynamic arrays, I find that this limitation affects about 50% of the models I build. The observable symptoms are blocks of 'fill-down' formulas involving @k#
    [k being a defined name applied to the anchor cell of a spilt array].

    Even worse is
    = INDEX( twoDArray#, @k#, 0 )
    [defining a row of the array]
    The functions then applied to such objects might be simple aggregations or functions such as FILTER and UNIQUE.

    The formula needs to be applied for every value of 'k#', hence the fill, but there may be no way of telling in advance how many terms there are within the array. This makes how far to fill a matter of guesswork.

    Peter Bartholomew shared this idea  · 
  3. 520 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi all,

    I’m happy to announce that your input has had another direct impact on the product. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc.. all of these will have Power Pivot. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. As such, it makes sense to make this as broadly available as possible.

    We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.

    Thank you for pushing for this!

    Ashvini Sharma
    PM Manager
    Excel

    Peter Bartholomew commented  · 

    Good news! Perhaps now, at last, spreadsheet programming will begin to move towards something more professional.
    Peter Bartholomew

  4. 9 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Bartholomew commented  · 

    Fully agree. The ability to create an index array is fundamental to the process of building solutions in Excel using it as one would a program. It exists in Power Query and should exist as an Excel worksheet formula. I could also see myself using it in the form

    = SEQ( 1, ROWS(myArray) )

    assuming the function defaults to give vertical array.
    The simplest form

    = SEQ(5)

    should be interpreted as giving {1;2;3;4;5}

    Peter Bartholomew supported this idea  · 
  5. 4 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Bartholomew shared this idea  · 
  6. 3 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 →
    Peter Bartholomew commented  · 

    If you wish to see an independent assessment of some models build using Names and Array formulas only go to

    https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling

    Despite the simplicity of the approach, changing the array dimensions to accommodate further time periods (for example) is still a pain and the arrays have to be adjusted one by one. The insertion of additional rows through an array formula is trapped as an error despite there being no ambiguity inherent in the process.

    If one could simply use a resize handle (as is done for Tables), all the tables linked to a given index could be automatically resized, so removing a significant source of error.

    This will never be implemented by popular demand. It is up to Microsoft to show leadership as they did for the implementation of Tables in Excel 2007 or the more recent Get and Transform that is aimed at supporting data analysts, as opposed to modellers.

    Peter Bartholomew shared this idea  · 
  7. 8 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Bartholomew supported this idea  · 
  8. 90 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Bartholomew commented  · 

    Full screen would be good. Even then, for a 1000x100 array formula, seeing just the first few rows/columns and the last would be good enough. It is unlikely that I would wish to check all 100,000 values.

    Peter Bartholomew supported this idea  · 

Feedback and Knowledge Base