Jon Peltier
My feedback
-
170 votes22 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier supported this idea ·
-
77 votes8 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
41 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
9 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
9 votes3 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier commented
Yet another problem is that the LAMBDA formula is not exposed to VBA. When you query the .RefersTo property of a Name, all you get is "=".
Jon Peltier supported this idea ·
An error occurred while saving the comment Jon Peltier commented
Another problem is that the Refers To box is stuck at one line only, while the Comments box is else to grow without limit. I've never used the Comments box, but I'm always stuck with the to small Refers To box, even if I'm not editing a Lambda function.
-
115 votes24 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier commented
I imagine we'll need more than 8192 characters in a formula soon, especially if we start to allow inline comments and indenting.
Jon Peltier supported this idea ·
-
23 votes6 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier commented
Also include it among VBA's WorksheetFunction offerings.
Jon Peltier supported this idea ·
-
2 votes1 comment · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Jon Peltier commented
I've never used the Select Objects tool to select objects in a chart or on a chart sheet, but I can see how it would be helpful. I can verify that it did in fact work in Excel 2010 and does not work in Excel for Microsoft 365.
Jon Peltier supported this idea ·
-
150 votes
Jon Peltier supported this idea ·
-
2 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
52 votes1 comment · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
289 votes43 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
58 votes0 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
We’d like to see how many votes this gets as a way to help us prioritize the work. Thanks!
Jon Peltier supported this idea ·
-
21 votes7 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
10 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
9 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
67 votes4 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
69 votes4 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
85 votes16 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Jon Peltier supported this idea ·
-
176 votes17 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.
Best,
John [MS XL]Jon Peltier supported this idea ·
I can envision hybrid dynamic array tables. Given a Table, I would like to write a dynamic array formula in a cell that spills into an entire column. Given a dynamic array formula, I'd like to convert the spill range to a Table, or at least apply some features of Tables to the spill range. The more I think of it, the more powerful and more complicated it sounds.