51–55 of 55 posts
Earlier quoted context omitted.
That would be awesome. With Sheets, I often jump into AppScript to write a quick javascript function to do what I want instead of having to deal with weird syntax. I wish I could do the same in Python.
FYI, I wasn't wishing, this is planned by MS.
[0] https://www.reddit.com/r/IAmA/comments/m22uc6/we_are_the_mic...
All these new text functions and still no support for regex? Google Sheets has had regex support for years.
I wish they completed the IF variants of statistical functions. Why do we have AVERAGEIF , but not AVERAGEAIF or GEOMEANIF , MAX and MAXIFS , but not MAXIF , etc? I can’t find logic in that. ( https://support.microsoft.com/en-us/office/excel-functions-b... ) Ideally, the “IF” would be a separate function that filters out cells, so that it could be used with VBA functions taking multiple cells, too. While at it, these…
There is a separate IF function https://support.microsoft.com/en-us/office/if-function-69aed...
Yes, you can create new cells that compute the Boolean, then use IF to populate a new range with the values that pass the test, and then call Foo on the new range, but avoiding such ‘pollution’ of spreadsheets is the whole reason these functions exist.
Array functions feel like they're just too far from the excel design thinking. A single function that affects nearby cells is hard for me to swallow. I kind of wish they went for the matlab cell array style where a function can return an array, but it just becomes a data structured stored within a single cell. So TEXTSPLIT (which is great, finally), would return an object like ARRAY("I", "SAW","A","CAT") and if you w…
Excel makes me feel like such a novice. I often just write a python script instead out of frustration. I don't think little of people that write complex formulas and macros with it. I am still waiting for "python in excel".