News for hackers. Stuff that matters.
Re:U.S. Army Chooses Google Workspace by arthurcolle on Monday October 10, 2022 @09:16PM (#33158324)
Has anyone had issues with normal INDEX/MATCH stuff in Google Sheets?

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

Re:U.S. Army Chooses Google Workspace by qntmfred on Monday October 10, 2022 @09:25PM (#33158389)
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.