Stack Overflow
Stack Overflow

Questions tagged [google-sheets-query]

Use for question about the QUERY function of Google Sheets.

Use this tag for questions about the QUERY function of Google Sheets.

QUERY is a non-standard spreadsheet function. It uses Google Query Language

It could be used together with

Usually it will not be used with

1444 questions
-1
votes
1 answer

How to grab Xpath query in Googlesheet IMPORTXML function?

Trying to grab from a link (https://www.valueresearchonline.com/stocks/1764/infosys-ltd?utm_source=direct-click&utm_medium=stocks&utm_term=&utm_content=Infosys&utm_campaign=vro-search#snapshot)- this is the relevant HTML: I've made the following…
Deepak G
  • 1
-1
votes
3 answers

How to calculate average of percentage for each row in Google Sheets

In column D, for each student I'd like to find average of percentage of all the tests they took. For Student 1, I need to take percentage of each test by 8/10, 25/25, 35/50 and find average in D6, etc. I tried =average(($E6:$E100)/($E3:$AB3)) but…
shin
  • 31,901
  • 69
  • 184
  • 271
-1
votes
1 answer

Return true/false on [strings in a cell] being found in [strings in another cell]?

Cell A1 contains multiple strings, eg "CAT DOG RAT GNU"; Cell B1 contains multiple strings, eg "RAT CAT"; How can I run a test (using formula in C1) to find if all the strings in B1 are present in cell A1? Returning true/false would be good Strings…
David Moore
  • 23
  • 5
-1
votes
1 answer

How to transpose a table by pivoting one column?

Question - How could I manage to get the required output (see image below) from the given input? Is it possible without having to write a macro or a script? Background - Input is transactions from your banks, so there can be multiple transactions…
Greg
  • 34,042
  • 79
  • 253
  • 454
-1
votes
1 answer

Google Finance Historical Data Multiple Attributes?

=GOOGLEFINANCE("NSE:"&A2, "all",(TODAY()-($N$2)),TODAY(),"DAILY") The above code returns OHLC data for specified days with the date column. What I want are only high, low and close columns. =GOOGLEFINANCE("NSE:"&A2, ("high", "low",…
Bhavesh Pamecha
  • 27
  • 6
-1
votes
1 answer

How to find something in one sheet and add it to another?

I have a problem with Google Sheets. I need to create a list based on the cell contents in the new worksheet. For example: If in the 'Example1' sheet, in cell E2, the value is 'yes', add the entire row to the 'Example2' sheet. Is it possible to do…
Kacper Możdżeń
  • 1
-1
votes
2 answers

DGET with multiple (compound) keys returns #NUM! error

What is the logic of the DGET function with multiple criteria keys? I have made two small examples to investigate: Case 1: we get a value by Date type key only - it works fine. Case 2: same data, but we add a String type key. Here we have an…
Александр Ермолин
  • 1,145
  • 1
  • 10
  • 17
-1
votes
2 answers

How to pull in only the most recent 10 results from a dataset?

Have a sheet with a lot of sports data... Row 1 has the titles of each column. Below that is data of individual games. Here's an idea of what it looks like, simplified. HomeTeam, AwayTeam, HomeGoals, AwayGoals, TotalGoals, Result Bruins, …
Grandaddycrunk
  • 21
  • 3
-1
votes
2 answers

Sum entries per date when multiple entries of date exist

I have 1 column of dates and 1 column of 'wins' recording 1 and -1 as wins and losses. I need a quick way to tally the score across each date (so I can graph the win-rates). Eg. 5th May 7 wins, 6th may -2 wins, etc. I have multiple entries for each…
Blackhart15
  • 31
  • 5
-1
votes
1 answer

How compare date parts in SUMIFS formula

I want compare a date part with a string and sum the values when the date part match with the string. $A2 is a YEAR STRING. Ex: 2019 'Other Sheet'!$U2:$U is a column with the values to sum when the condition returns true. 'Other Sheet'!$E2:$E is a…
FabianoLothor
  • 2,752
  • 4
  • 25
  • 39
-1
votes
1 answer

I want to identify duplicates and keep the most recent one and delete the other in Google Sheets

I want duplicates in my data identified. Once I have this data I want to sort the duplicates by date and keep the most recent one. I cannot not provide a copy of my sheet because of the sensitive information inside.
retter
  • 23
  • 4
-1
votes
1 answer

Trying to insert a text function into QUERY - how to escape a string in this situation?

I am setting up some report data in App Script, using QUERY over IMPORTRANGE. All is fine until I try to insert a function to extract the short form string month [ie TEXT(Col4,"MMM")] from a date column into the query. As far as I can tell, "MMM"…
SM.
  • 79
  • 1
  • 9
-1
votes
2 answers

How to sort this query correctly?

I have this demo sheet I need to sort the query in cell I3 correctly by Column M I have this formula =ArrayFormula(IFERROR(QUERY({ IFERROR(QUERY({A3:G},"Select Col1,Col2,Col3,'30',Col5 where Col5 contains 'Days' Label '30' ''…
SATH59
  • 149
  • 1
  • 3
  • 15
-1
votes
2 answers

Google Sheets sum rows with the same first cell value grouped by first row value

I have dynamic data for an online shop with sales by product, by week split into columns: I want to create a header row of the unique weeks and summarise the total sales by product by week in a dynamic table using query and or array formula if…
Adam Miller
  • 1
  • 3
-1
votes
1 answer

How to make a Query formula in Google Sheets for an inventory per month columns

I'm making a dashboard in google sheets for my inventory. i am using query function to populate a section of the dashboard with data as a summary. my source data is set up as item name, type, january, february, march, april, may.... with quantities…
KCruz
  • 1
1 2 3
…
96 97