Why am I getting the error “Resource at url not found” with this importxml function?
The function is
=importxml(“https://scryfall.com/search?as=grid&order=name&q=type%3Aaetherborn+color%3E%3DW+%28game%3Apaper%29+legal%3Avintage”,”//strong[1]”)
This should say “0 cards found”
How do I count “Not Empty” Values in this OR that column IF another column matches a dynamic value
I’m trying to count the number of times either of two cells is not empty/not blank where another cell in the same row contains a specific string.
Simplify a google sheets formula so i don’t have to do it column by column
=ARRAYFORMULA( IF( ISNUMBER(SEARCH(“LST”, A2:A7)), FILTER(REGEXEXTRACT(A2:A7, “[0-9]+”), ISNUMBER(SEARCH(“LST”, A2:A7))) & ” ” & A$1, IF( ISNUMBER(SEARCH(“LST”, B2:B7)), FILTER(REGEXEXTRACT(B2:B7, “[0-9]+”), ISNUMBER(SEARCH(“LST”, B2:B7))) & ” ” & B$1, IF( ISNUMBER(SEARCH(“LST”, C2:C7)), FILTER(REGEXEXTRACT(C2:C7, “[0-9]+”), ISNUMBER(SEARCH(“LST”, C2:C7))) & ” ” & C$1, “” )))) I have this formula and need to make it so I don’t have to do it […]
Parse error when I use Col that is greater than 9 in QUERY parameter
I have the following QUERY that I am using with IMPORTRANGE in GoogleSheets.
Google Sheet – If formula
I need help writing a formula that cell’s B7 & C7 will return specific text if cell J7 has specific text. (See below)
How to calculate average days of spend return with single arrayformula
In my Google Sheet (see my example sheet here), I have 2 tabs, a Main tab which lists names in A3:A, and a Data Tab in which the names appear somewhere in B1:1, and three columns of data under each name, named SPEND, INCOME, and MISC. A3:A contains Dates in ascending order.
Formula to to find median of different tasks having different count by using unique task
Hi i got a problem where I need to calculate median of a table having two columns i.e..task and count..
Task–count
A1—-23
A1—-20
A2—-15
A2—-10
A2—-
A3—-5
A3—-7
A3—-12
Count values in exact row
I want to count number of times a specific value shoes up in an exact row. For example, the table in the picture, if I write 501 under ID and add value 3, it should count all threes in second row (id 501)…enter image description here
Count values in exact row
I want to count number of times a specific value shoes up in an exact row. For example, the table in the picture, if I write 501 under ID and add value 3, it should count all threes in second row (id 501)…enter image description here
How do I generate a running total based on dates in Google Sheets using Query Function
Date Income 03/12/2023 $400 03/19/2023 $200 03/21/2023 -$200 04/02/2024 $500 05/18/2024 $350 05/22/2024 -$100 05/31/2024 -$25. I need some guidance on how to use query function to generate running total for above table. The table needs to be grouped by end of the month based on the year (Pivot for the year). thanks in advance. […]