Arrayfomula with filter on entire column
I’m trying to build a Google Sheets formula to have a column that lists an array (can concatenate) of products ordered in the first order of a customer.
Google Sheets: Arrayfomula with filter on entire column
I’m trying to build a Google Sheets formula to have a column that lists an array (can concatenate) of products ordered in the first order of a customer.
Find match in a specified column, then find match in the matched row?
I’m trying to write a Google Sheets formula that returns the value in row 4 of an unknown column. The column should find a given string (E.g., “Lock”) in the row whose A-column cell value matches a given number (E.g., “103”).
Google Sheets – complex search formula – finding a value next to a string to replace conditionally with array formula
I need to check a column of values and assign them the correct type. This is partially achieved as there is another column that has the classifications, but I need to make some corrections. The values contain strings of characters that if found, should allow be to reclassify them. I need to locate those strings and compare them to a reference sheet, that has the types that I need.
Use list of keywords from sheet B to search string on sheet A, if match then show value from different cell from Sheet B – String Search & Categorize
I am trying to use a list of keywords in sheetB ColumnB to search strings in sheetA ColumnB.
How in google spreadsheets =QUERY search item with ” in the title
I have QUERY formula
In a tournament, how do I figure out head 2 head between tied teams?
No expert here. My spreadsheet tracks results in a tournament. I would like to analyze head to head between teams, especially when there is a tie. Could be 2 way tie or multiple ties. Please see attached image. Do I need to format the data differently? Can this be done with formulas or best handled as an app script?
Google Sheets Conditional formatting issue using ifna()
I have a Google Sheet that has 2 columns in it. The first column, Column A, is a list of ticket numbers. The second column, Column D, is a list of winning ticket numbers. I would like the list of ticket numbers to have the cell highlighted if it is in the list of winning tickets.
Importrange with indirect
Im trying to pull data off another sheet using ImportRange which if i type everything out(=Importrange(“URL“,”8!AD4”) it works fine
I want to make the 8 in the “8!AD4” reference a cell in the sheet I’m working in. I tried to use
=Importrange(“https://URL“, INDIRECT(AI6) &”!AD4″)
How to delete a Sheety project?
I have two projects of the same name in my Sheety dashboard. Both projects are linked to the same google sheet, which was created by someone else. I would like to delete both projects and create a new one using my own google sheet.