Erik Tyler's user avatar
Erik Tyler's user avatar
Erik Tyler's user avatar
Erik Tyler
  • Member for 5 years, 6 months
  • Last seen this week
6 votes
Accepted

Rearrange Name Format in Google Sheets using one formula only

4 votes
Accepted

Using Google sheets `QUERY` instead of `VLOOKUP` - function returning empty - why?

4 votes
Accepted

Google Sheets - existing row formulas are being erased after Google Form submission

4 votes
Accepted

No query result when one of the columns used in the output never has a value

4 votes

How can I generate a Random Number that does not change in Google Sheets?

3 votes
Accepted

Why does Google Sheets Conditional Formatting not apply properly to all cells?

3 votes
Accepted

Formula to output the date for next Friday once it has passed 20:00 on Friday

3 votes
Accepted

Summing Columns Based off Different Criteria in a group by in a Query Function in Google Sheets?

3 votes
Accepted

Google Sheet color rows 2 by 2

3 votes
Accepted

Select full column in Google Sheets by [@column]

2 votes
Accepted

How to sort a list-like text in a cell?

2 votes
Accepted

Extract original text from cell with LEFT formula

2 votes

What's the "if text contains" formula in Google Sheets?

2 votes
Accepted

How do I convert a minute number to human-readable format in google sheet?

2 votes

How to calculate compound interest based on bottom x rows of a spreadsheet in Google Sheets

2 votes
Accepted

Formula to count the number of different letters in a word

2 votes

How to sum one row of multiple selected columns where a col matches a condition, but return null string instead of "0" if no match

2 votes

How to format a google sheet that's capturing google form data?

2 votes

How to have a query wrapped in an arrayformula auto-populate many rows

2 votes
Accepted

How to fill range of cells with same value using formula?

2 votes
Accepted

Can we simplify the if-zero condition

2 votes

In Google Sheets, can you repeatedly autofill until next non-blank cell all at once?

2 votes

Google Sheets Query with importrange by date range

2 votes
Accepted

Check if Google Sheet cell contains string from range of cells

2 votes

Create serial count in column if adjacent cell is blank (Google Sheets)

2 votes

Count number of line breaks in Google Sheets cell

2 votes
Accepted

How can I turn 1.2M into 1,200,000 in Google Spreadsheet?

2 votes

What's the best way to upload a million row spreadsheet as Google spreadsheet?

2 votes

Query using starts with

2 votes
Accepted

Skip a specific number of rows while pulling data from another worksheet

1
2 3 4 5
11