I would like to count the total occurrences of series that have “Action” as a main genre and then “Magic” as one of it’s other tags. Currently I have: L being the row where the main genre is listed. Following that row (M:BM) are a bunch of tags. Is it possible to use query to tal…
Tag: google-sheets
SELECT DISTINCT sum in google sheet
i’ve a sheet like this: Month(Col11) Team (Col2) 03 luna 03 luna 04 pippo 04 gigi 04 luna 04 gigi 04 pippo 04 luna 04 luna 04 pippo 04 pippo 04 grisbi 04 grisbi 05 luna 05 luna 05 pippo 05 pippo 05 grisbi 05 grisbi i need the sum of unique of each month, a result like this: Month(Col11)
How to send values to automatic sequential rows in an arrayformula on gsheets?
This would be much easier to solve on the 1* data sheet, but I am trying to have grouped data with a weekly quantity broken down into a daily # to make work easier further down the line. =query({…
Google sheets query – I would like to return a column, but if cells in the column are empty return cells in another column instead
Kinda new at this, struggling with a solution. So currently my formula looks like this: Col2 is my criteria and remains constant. What I’m looking to do is have the formula return the cell in Col9 if the cell in Col8 is empty. If the cell in Col8 is not empty it will just return as is. Col8 is not
Is there a way to pair entrys by rows to give pairs such that there is maximum overlap by columns?
Sorry, for the poor phrasing. I am struggling to find a good way to describe this problem, so I will go with an example. Say I have a bunch of people that I need to pair up together based on similarities between rows. If my data looked like something below, how would I go about pairing people up by the
How can I refer to 2 differents dataset into a gsheet query formula?
I’m trying to get a formula to match 2 different data set in google sheets. I did the following but I keep getting “parse error” With D10 is the cell that I’ll look up the match for. Let me know if you have any tips and thanks! Answer The syntax for QUERY is QUERY(data, query, [headers…
Google Sheets – Parse unsorted comma separated values from one column, into separate columns. The values are not always in the same order
Three example rows from that column are shown below. My desired outcome would be: e.g. Any help would be great 🙂 Answer Indeed it looks like JSON. You could replace all the ‘ with ” and paste the records here: https://codebeautify.org/jsonviewer The complete string for the examples you provided wo…
Find Duplicates on Multiple Criteria
I have a set of financial transactions with a Date, Amount, Description and Source and I want to find transactions where the amount is the same, the date is within one day, but the sources are …
Adding sheet name as column to query in Google Sheets
I have a Google Sheets document with my video game collection. Each console system has its own sheet, but I decided to consolidate all sheets into one new sheet as an overview using a query that looks something like this: This works fine, and I’m satisfied with it. However, my collection is quite large …
How to use substring and charindex in google query language
I have a google spreadsheet sheet with several columns: A: date B: string C: number … G: string (could be empty) H: string (could be empty) I would like to have a small table with the following: Get the sum of C in table, where rows are the values of G (substring of it, as they are configured as this: