JPV's user avatar
JPV's user avatar
JPV's user avatar
JPV
  • Member for 9 years, 4 months
  • Last seen more than a month ago
  • Belgium
26 votes
Accepted

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

20 votes
Accepted

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

5 votes

Join two columns in Google Sheets

5 votes
Accepted

Google Spreadsheet Query for unique and "most recent"

5 votes
Accepted

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

5 votes

Convert table data into a list in Google Spreadsheet

5 votes
Accepted

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

4 votes
Accepted

Get unique rows and their count in Spreadsheet

4 votes
Accepted

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

4 votes
Accepted

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

4 votes
Accepted

Delete second row in a cell in Google Spreadsheet

4 votes

Sum a column if another column contains any of the values

4 votes

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

4 votes
Accepted

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

4 votes

How can I COUNT rows with ARRAYFORMULA?

3 votes

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

3 votes
Accepted

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

3 votes

Parse error with =IF function

3 votes
Accepted

Add timestamp to two different columns in Google Spreadsheets

3 votes

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

3 votes
Accepted

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

3 votes

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

3 votes

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

3 votes
Accepted

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

3 votes
Accepted

Simplifying Google Form Checkbox Responses into Itemized List

2 votes

How to filter everything in one column out of another

2 votes
Accepted

Sorting Pre-Sorted Google Form Data by Timestamp

2 votes

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

2 votes
Accepted

Script to Create Copy (Backup) of entire spreadsheet onOpen

2 votes

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