Reputation
10,327
Next privilege 15,000 Rep.
Protect questions
Badges
7 29 76
Impact
~913k people reached

16h
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/…
1d
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 !!
2d
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?
Jun
24
comment Delete duplicate text within a cell
How would your formula deal with Black Black and Black White?
Jun
17
comment Send email with PDF attachment located in Google Drive
As Amit explains, try your luck with this answer: webapps.stackexchange.com/a/61069/29140:
Jun
15
comment Google Sheets: Format number as Mhz/kHz, or MB, kB etc
Have a look at this answer: webapps.stackexchange.com/a/78069/29140
Jun
14
comment What is the correct format for blogger import xml file?
This is somewhat a question that involves web development.
Jun
12
comment How can I create a URL for a specific cell in Google Sheets?
Hi Rachael and welcome on Web Applications !! Would you care to share the formula with us and the error message, so that we can have a better understanding of what's happening.
Jun
11
comment How to format the date in this Google Docs script
Thanks Edelans. Updated my answer.
Jun
6
comment Google form to spreadsheet, create new column
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post.
Jun
5
comment How to create an automatically updating Google spreadsheet with information from Steam?
@user95432 Why don't you post that as a question and we'll have a look at it !!
Jun
5
comment How to create an automatically updating Google spreadsheet with information from Steam?
@user95432 You can use the QUERY formula to do that. Add the following in sheet 123: =QUERY('Other Sheet Name'!A:G; "SELECT A, D, G")
Jun
5
comment How to create an automatically updating Google spreadsheet with information from Steam?
@user95432 Try to use a semicolon (;) instead of a comma (,): =IMPORTXML("http://steamcommunity.com/id/PerfectPlays"; "//span[@class='actual_persona_name']")
Jun
3
comment Show path on Google Maps
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.
Jun
2
comment How to show multiple points at Google Maps?
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.