Reputation
10,740
Next privilege 15,000 Rep.
Protect questions
Badges
7 31 78
Newest
 Revival
Impact
~952k people reached

Jul
29
comment Automatically add rows daily and append previous day's data
Cant you make that work by using an ARRAYFORMULA or use QUERY to contruct the other sheet?
Jul
27
comment Text to columns conversion in Google Spreadsheets
GAS isn't deprecated. It's the script gallery that's being replaced by the Add-on store !!
Jul
27
comment Google Spreadsheets date and time format
@jamesmstone the DATEVALUE formula exists in both versions.
Jul
24
comment Google Spreadsheets date and time format
The TIMEVALUE formula only exists in the new Google Sheets.
Jul
23
comment In a Google Spreadsheet, how can I force a row to be a certain height?
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.
Jul
23
comment Create a popup in Google Spreadsheet
They're part of the getUi(), see: webapps.stackexchange.com/a/67910/29140
Jul
23
comment Create a popup in Google Spreadsheet
The prompt and alert methods within the SpreadsheetApp can be of use as well.
Jul
23
comment Formula to show text based on numbers
Welcome again......
Jul
23
comment Formula to show text based on numbers
Thanks for posting Amina. The VLOOKUP formula is very useful !! If you search Web Applications, you will find multiple cases involving the usage of the VLOOKUP formula: webapps.stackexchange.com/search?q=vlookup. Welcome on Web Applications !!
Jul
21
comment Sum 4 rows in every 5th column
Have you tried replacing the comma (,) for a semi-colon (;)?
Jul
20
comment Setting multiple protected ranges with one range value inputted
Hi sam, just out of curiosity, did my solution work?
Jul
6
comment Clear range of cells
Hi (Hoi) Joris, please mark the answer as best answered. This not only gives credit to 1999, but also indicates to future visitors the best (and only) answer. Take the tour to learn more about the site: welcome on Web Applications !!
Jul
5
comment Using query to find the entries in one column which are not in the other
Hi 1999, I based my comments on the sample file I prepare. Have a look if you will: docs.google.com/spreadsheets/d/…
Jul
4
comment Using query to find the entries in one column which are not in the other
I don't understand what you are looking for John. The QUERY formula you posted, works just fine and is way more easy then the formula 1999 posted. Do you want to have only one entry? Please share an example doc with us that shows the expected outcome, so we can have a better understanding of the problem. Welcome on Web Applications !!
Jul
3
comment Google Spreadsheet formatting a cell with wordwrap without switching modes?
+1; Perhaps it is better for Eight Days to incorporate this into his answer. Welcome on Web Applications !!!!!
Jul
1
comment Using HLOOKUP for date values
@jpv see comments, example sheet added
Jul
1
comment Using HLOOKUP for date values
Why don't you share an example document with us, so we can have a look?
Jun
30
comment How to calculate interest rate from start and end amounts in Google Sheets?
=RATE(240,0,-38106,73036) equals 0.27%
Jun
29
comment Setting multiple protected ranges with one range value inputted
You could build a small UI in GAS to input the ranges into?
Jun
26
comment How to automatically increase the exponent in Google Spreadsheet columns?
Try wrapping that in an ARRAYFORMULA?