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

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
Jul
2
reviewed Edit Gmail Filter Not Forwarding Email
Jul
2
revised Gmail Filter Not Forwarding Email
removed thank you massage and removed email tag
Jul
1
reviewed Close I forgot my username and password
Jul
1
comment Using HLOOKUP for date values
@jpv see comments, example sheet added
Jul
1
revised Using HLOOKUP for date values
styled body text
Jul
1
comment Using HLOOKUP for date values
Why don't you share an example document with us, so we can have a look?
Jul
1
revised Calculate compound interest rate in Google Spreadsheet
styled body text
Jul
1
revised How to calculate interest rate from start and end amounts in Google Sheets?
rolled back to a previous revision