Peter Bartholomew
My feedback

40 votes3 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Peter Bartholomew supported this idea ·

2 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →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 'filldown' 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 · 
520 votes255 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
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
ExcelPeter Bartholomew commentedGood news! Perhaps now, at last, spreadsheet programming will begin to move towards something more professional.
Peter Bartholomew 
9 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →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 · 
4 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Peter Bartholomew shared this idea ·

3 votesPeter 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/projectupdates/multicellarraymodelling
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 · 
8 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Peter Bartholomew supported this idea ·

90 votes24 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →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 ·
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.