User JPV

27 votes

Accepted

How to skip blank cells when copying a range from source to destination by Formula

answered Jan 10, 2015 at 8:41

20 votes

Accepted

Google Spreadsheet: Count column if criteria is met in the respective column and another column

answered Mar 27, 2015 at 13:04

6 votes

Accepted

Google Spreadsheet Query for unique and "most recent"

answered Mar 24, 2015 at 8:47

5 votes

Accepted

Return transposed list of all strings in a row in Google Sheets

answered Mar 26, 2015 at 12:32

5 votes

Join two columns in Google Sheets

answered Feb 17, 2015 at 21:02

5 votes

Convert table data into a list in Google Spreadsheet

answered Jan 17, 2015 at 9:01

5 votes

Accepted

How do I interleave two lists or data in Google Spreadsheets?

answered Jun 16, 2015 at 12:35

4 votes

Accepted

Get unique rows and their count in Spreadsheet

answered Aug 5, 2015 at 11:21

4 votes

Accepted

Turn a table into a list of row/column/value tuples

answered Apr 30, 2015 at 14:10

4 votes

Accepted

In Google Sheets, can you apply a regex to a generated range?

answered May 1, 2015 at 17:41

4 votes

Accepted

Delete second row in a cell in Google Spreadsheet

answered Apr 11, 2015 at 14:13

4 votes

Sum a column if another column contains any of the values

answered Jan 9, 2016 at 16:01

4 votes

An arrayformula to find the previous non-empty cell in another column

answered Mar 2, 2016 at 9:09

4 votes

Accepted

Google Spreadsheet: How to fill in missing values (inbetween filled values) automatically

answered Jan 15, 2015 at 9:32

4 votes

How can I COUNT rows with ARRAYFORMULA?

answered Jan 6, 2015 at 19:18

3 votes

How do I refresh script results when a cell color is changed?

answered Dec 23, 2014 at 23:03

3 votes

Accepted

Google Sheets - Auto update table and auto add new data entries

answered Jan 15, 2015 at 19:27

3 votes

Parse error with =IF function

answered Feb 9, 2015 at 7:04

3 votes

Accepted

Add timestamp to two different columns in Google Spreadsheets

answered Feb 25, 2015 at 10:17

3 votes

How do I check if a cell is blank for Conditional formatting?

answered Mar 13, 2015 at 12:58

3 votes

Accepted

If value of cell equals X, get value of adjacent cell, then add to totals

answered Apr 7, 2015 at 18:11

3 votes

Split a column of strings with a single formula returning an array

answered Jan 10, 2016 at 10:12

3 votes

How to count numbers in nearby cell with criteria in Google Sheets

answered May 5, 2015 at 9:27

3 votes

Accepted

If time is before 17.00 use 17.00 OR if time is after 17.00 use value in cell

answered May 12, 2015 at 10:11

3 votes

Accepted

Simplifying Google Form Checkbox Responses into Itemized List

answered Oct 11, 2015 at 16:58

2 votes

How to filter everything in one column out of another

answered Oct 22, 2015 at 7:50

2 votes

Accepted

Sorting Pre-Sorted Google Form Data by Timestamp

answered Nov 11, 2015 at 9:55

2 votes

Average of last 7 non-empty non-blank cells in Google Sheets

answered Nov 23, 2015 at 10:31

2 votes

Accepted

Script to Create Copy (Backup) of entire spreadsheet onOpen

answered May 20, 2015 at 6:55

2 votes

Applying a Formula to All Cells in a Column (Even New Cells)

answered Jun 8, 2015 at 20:35

Stack Exchange Network

66 Answers

How to skip blank cells when copying a range from source to destination by Formula

Google Spreadsheet: Count column if criteria is met in the respective column and another column

Google Spreadsheet Query for unique and "most recent"

Return transposed list of all strings in a row in Google Sheets

Join two columns in Google Sheets

Convert table data into a list in Google Spreadsheet

How do I interleave two lists or data in Google Spreadsheets?

Get unique rows and their count in Spreadsheet

Turn a table into a list of row/column/value tuples

In Google Sheets, can you apply a regex to a generated range?

Delete second row in a cell in Google Spreadsheet

Sum a column if another column contains any of the values

An arrayformula to find the previous non-empty cell in another column

Google Spreadsheet: How to fill in missing values (inbetween filled values) automatically

How can I COUNT rows with ARRAYFORMULA?

How do I refresh script results when a cell color is changed?

Google Sheets - Auto update table and auto add new data entries

Parse error with =IF function

Add timestamp to two different columns in Google Spreadsheets

How do I check if a cell is blank for Conditional formatting?

If value of cell equals X, get value of adjacent cell, then add to totals

Split a column of strings with a single formula returning an array

How to count numbers in nearby cell with criteria in Google Sheets

If time is before 17.00 use 17.00 OR if time is after 17.00 use value in cell

Simplifying Google Form Checkbox Responses into Itemized List

How to filter everything in one column out of another

Sorting Pre-Sorted Google Form Data by Timestamp

Average of last 7 non-empty non-blank cells in Google Sheets

Script to Create Copy (Backup) of entire spreadsheet onOpen

Applying a Formula to All Cells in a Column (Even New Cells)