I need help to create a sheet for a game. I am providing the INPUT, and I would like to create the OUTPUT in another tab (do not consider the colors, its just for ease of understanding):
Mainly, the ...
I'm not sure what is happening in my Google Sheet query and could really use some help. I have a quick screencast that demonstrates and explains the issue.
Basically, I'm using a query to pull data ...
I'm using the following query to pull data from one sheet into another.
=query(data!B2:CL,"select B, C, D, E, F, G, H, I, J, BB, BZ, CA, BA where J = 'Industry Certification'",false)
The above query ...
I'm trying to figure out how to update the following Google Spreadsheets query function so it can search column "J" for three or more separate values. If any of the values are present in column "J", I ...
I have a table like so:
| A | 100 |
| B | 125 |
| C | 454 |
| A | 234 |
| A | 343 |
| B | 222 |
| C | 754 |
I have several queries. Each week they need to shift one column right, C to D then E...W.
I currently manually change C to D in all my queries and I want to simplify.
A couple of examples:
I am using the function below to QUERY an IMPORTRANGE range based on IS NOT NULL conditions:
I'm trying to perform a query through an imported range, but whenever I have an empty cell in the first column, it gives me a cell that is a combination of ALL of the cells that have an empty Col1 at ...
Recently, someone on this forum put together a formula for me. It works on a sheet pulling responses from a google form. I'm trying to model a new one after that but I'm having trouble. The working ...
I have a long list of date times (timestamps) in column A, attached to some data in column B. I want to group this data by day, obtaining the count of events and the totals for each day. For example, ...
I'm using a Query in Google Sheets to pull data from another sheet. That query looks something like this:
=QUERY('Raw Data'!A2:AB,"SELECT E, A, C, D, Y, R, S WHERE S = 'New York'",1 )
What I'd like ...
I've started using Google Sheets for our logbook and it's been a great help. I have data with a time component in it (start and end time) and I'd like to query or filter the data where the start time ...
I want to filter an array returned by a filter to remove blank columns. Here is a picture of an example sheet:
Here is the example sheet.
I am filtering the large table by the rows that are of type ...
In my spreadsheet the chart for Negative Feedback weekly pulls data from the Query sheet, but the logic doesn't work to separates negative feedback from positive feedback. The logic works fine on the ...
I have numbers in range D7:D and there are times when some cells are empty. I want the average of the last 7 numbers but to skip blanks. So if in the last 7 there's only 3 that are full, I want it to ...
I have a column in Sheet1 that contains dates in format DD/MM/YYYY, like this: