Reputation
11,035
Next privilege 15,000 Rep.
Protect questions
Badges
7 31 79
Newest
 Revival
Impact
~991k people reached

Jul
9
revised Restore a Google Sheet
capitalisation, punctuation, grammar (and removed name); please make your edits count @seranat
Jul
8
reviewed Reviewed How to lock a Google Document?
Jul
7
reviewed Edit Static Image URL using Bing Maps with Polygon Shape
Jul
7
revised Static Image URL using Bing Maps with Polygon Shape
formatted link and added a screenshot
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
6
revised Clear range of cells
styled body text, grammer, punctuation, removed script tag
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
revised Google Sheets “Skipping blanks”
small mod.
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
4
revised Setting multiple protected ranges with one range value inputted
minor typos
Jul
4
revised Setting multiple protected ranges with one range value inputted
added different approach so that all sheet names are covered
Jul
4
revised Setting multiple protected ranges with one range value inputted
added 300 characters in body
Jul
4
revised Setting multiple protected ranges with one range value inputted
added 306 characters in body
Jul
4
answered Setting multiple protected ranges with one range value inputted
Jul
3
revised Import Google Contacts to Google Spreadsheet
deleted 5 characters in body
Jul
3
revised Import Google Contacts to Google Spreadsheet
styled body text, retagging
Jul
3
answered Import Google Contacts to Google Spreadsheet
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
2
reviewed Reject and Edit Google Sheets permissions
Jul
2
revised Google Sheets permissions
styled body text and removed thanks