nope. i tend to use QUERY() in sheets these days anyways. more versatile
Re:U.S. Army Chooses Google Workspace
by arthurcolle on Monday October 10, 2022 @10:23PM
(#33158781)
I'll check this out, thanks.
Re:U.S. Army Chooses Google Workspace
by jimmygrapes on Monday October 10, 2022 @09:22PM
(#33158364)
IME in a similar industry, Google Sheets is to (desktop) Excel what a $30 Casio USB "MIDI" keyboard is to a Craigslist Steinway
Re:U.S. Army Chooses Google Workspace
by RockingGoodNite on Monday October 10, 2022 @10:22PM
(#33158774)
No one really uses spreadsheets any more except as nicer CSV outputs.
Re:U.S. Army Chooses Google Workspace
by stjohnswarts on Monday October 10, 2022 @11:04PM
(#33159027)
Sure they don't. Not everything is ML and datascience. You'd be surprised what untrained people who like to experiment can cobble together in offices.
I was actually OK with moving from Excel to Google Sheets since the coverage of functions seemed mostly ok, minus all the new cool shit they added in one of the more recent releases (XLOOKUP, etc) but I literally tried a trivial INDEX/MATCH with a simple 5x20 matrix of price values and literally could not get it to work even though the identical "code" worked in Excel.
Really, really frustrating. I was working at a hedge fund at the time and I was simultaneously working on a real time portfolio dashboard as a web app, and needed to also have a stopgap solution in the form of a spreadsheet for people to play with and debugging differences in Google's spreadsheet function implementations and Excel's was infuriating