173 reputation
211
bio website
location Cambridge, United Kingdom
age 94
visits member for 4 years
seen Aug 6 at 13:07

Interested in web standards, semantics, communication, history of science, and the - uh - universe...

Increasingly disillusioned by Stack Overflow and the rest of the Stack Exchange system, for reasons overlapping those articulated here by Michael Richter and here* by Benjamin Mako Hill.

*Stack Exchange sites are worse than GitHub in this respect.


Nov
19
awarded  Notable Question
Aug
5
answered Extract and sum numbers from a cell containing text that contains numbers
Aug
3
comment Extract and sum numbers from a cell containing text that contains numbers
Thanks. I tried REGEXEXTRACT before posting my question because its name and Google's summary description of it intuitively suggested to me that it would be the appropriate function. However, it doesn't seem to be terribly useful for my use case, so either my intuition was off or its name and description were poorly chosen. Anyhow, I decided not to mention it in my question, in case people got the idea I was somehow wedded to using it :)
Aug
3
accepted Extract and sum numbers from a cell containing text that contains numbers
Aug
3
asked Extract and sum numbers from a cell containing text that contains numbers
Mar
1
awarded  Notable Question
Feb
19
awarded  Popular Question
Nov
23
awarded  Popular Question
Aug
13
awarded  Critic
Aug
13
awarded  Scholar
Aug
13
accepted Google Spreadsheets: how to specify entire sheet as range?
May
29
comment Google Spreadsheets: how to specify entire sheet as range?
Thanks, but my current workaround does not require one to know how many rows the sheet has, nor how many columns it has as long as it has <676 columns.
May
28
comment Google Spreadsheets: how to specify entire sheet as range?
I appreciate the effort, but as far as I can tell, your suggestion yields no advantages over the workaround I mentioned in my question, but has the disadvantages of being more verbose and requiring the user to input a character that won't ever be present in the sheet.
May
19
awarded  Tumbleweed
May
12
awarded  Editor
May
12
revised Google Spreadsheet: how to get value of cell by row key and column key
Restored relevant tags. Added P.S.
May
12
comment Google Spreadsheet: how to get value of cell by row key and column key
Thanks, but I think you missed the part where I said, "by using the column name ... and the row name". :)
May
12
asked Google Spreadsheet: how to get value of cell by row key and column key
May
12
asked Google Spreadsheets: how to specify entire sheet as range?
Jul
11
comment Search by thread rather than email in Gmail
Thanks, phwd :) Although it would be ideal to get a solution that doesn't require programming, if you've got a solution that does require programming, I'd still be interested in it, so please do post a link to the relevant JSfiddle or PasteBin or what-have-you.