Re:New Text and Array Functions for Excel
by dhosek on Tuesday September 06, 2022 @05:47PM
(#32743645)
The functionality I want is a count-by-format function. I had to write my own in VBA and of course that means every time I open that sheet I have to approve its use of macros (and it also doesn’t always catch format changes that impact the calculation)
[ Parent
| on HN ]
Re:New Text and Array Functions for Excel
by auxym on Tuesday September 06, 2022 @06:30PM
(#32744048)
Encoding data in cell formatting is questionable practice.
Re:New Text and Array Functions for Excel
by JadeNB on Tuesday September 06, 2022 @06:56PM
(#32744249)
> Encoding data in cell formatting is questionable practice.
"Let's force the user to employ data-management best practices" is, for better or for worse, very much not the design philosophy of Excel. (More to the point, if you must consume the data that someone else produces, then you'd like very much to be able to deal with their less-than-best practices.)
Re:New Text and Array Functions for Excel
by function_seven on Tuesday September 06, 2022 @06:58PM
(#32744261)
Agreed, but I can’t control half the sheets I interact with.
Users really like to highlight rows, or use coloring to track their progress, or do some insane multi-color-mixed-with-other-formatting system to indicate complex statuses.
I’d like to be able to work with that terrible data.
Re:New Text and Array Functions for Excel
by dhosek on Tuesday September 06, 2022 @09:26PM
(#32745343)
Why? Because the tools don’t provide nice ways to interact with it? I use colors and other formatting as ways of providing metadata to cells that I want to be able to move around in the spreadsheet.
Re:New Text and Array Functions for Excel
by richardpetersen on Wednesday September 07, 2022 @01:07AM
(#32746552)
Can’t you achieve that with the new excel lambda function?