JPV

JPV has asked 0 questions and find answers to 46 problems.

Stats

About

Administrator of a Google Apps domain (for education). Top contributor at the Google Docs Help Forum Personal interests: google apps script, javascript, google sites (webapps) etc..

JPV questions

JPV answers

How to use IFERROR inside an array formula?
How can I escape double and single quotes in google sheets query?
Google sheet formula =$G1=
using both QUERY and FILTER together in a single statement?
Extracting and counting unique word frequency from a range
How to SUMIF with an array in Google Sheets
Google Sheets: Range Not Found
conditional formatting apparently not working as expected in google spreadsheet. did the opposite of evaluating less than or equal to
Extract rows from one google sheet to another based on criteria in column
COUNTA in current row in an array formula (Google Sheets)