Search code examples
Google sheets select field by maximum timestamp & specific cell value...

google-sheetstimestampmatchvlookupgoogle-query-language

Read More
Google Sheets: EXCLUDE hidden rows in query pulling unique data using indirect function...

arraysif-statementgoogle-sheetsuniquegoogle-query-language

Read More
Count Number of Consecutive Occurrence of values in Google sheets...

if-statementgoogle-sheetsvlookupcountifgoogle-query-language

Read More
Google Sheets: How to combine multiple rows in their own cells according to an ID?...

google-sheetspivotgoogle-sheets-formulagoogle-query-languagetextjoin

Read More
If or query, if criteria is met, copy from other sheet...

google-sheetsmatchvlookupgoogle-formsgoogle-query-language

Read More
Google Sheets QUERY pulling from a list of tab names which will pull new tab data as new tabs are ad...

arraysif-statementgoogle-sheetsexcel-formulagoogle-query-language

Read More
Google Sheets - Combine multiple columns into one with unique values...

google-sheetsgoogle-query-language

Read More
Query multiple google sheets in different sheets with sheet name in column1...

arraysgoogle-sheetsfilterarray-formulasgoogle-query-language

Read More
Google Sheets - How to count streaks of non-zero numbers on one column...

arraysgoogle-sheetsmatchflattengoogle-query-language

Read More
Filtering multiple columns in Google Sheets without blanks...

arraysgoogle-sheetsfiltergoogle-sheets-formulagoogle-query-language

Read More
Autofilling spreadsheet row when date is (ex: today) and value "name" is in that row...

excelgoogle-sheetsgoogle-sheets-formulavlookupgoogle-query-language

Read More
Trying to combine the sums of a filter into one cell...

arraysgoogle-sheetsfiltersumgoogle-query-language

Read More
How to create a total quantity based upon multiple criteria from 2 arrays...

arraysgoogle-sheetssumvlookupgoogle-query-language

Read More
Generate a new dataset from two existings datasets with conditions...

arrayssortinggoogle-sheetsfiltergoogle-query-language

Read More
Query or formula that takes data from different ranges...

arrayssortinggoogle-sheetsvlookupgoogle-query-language

Read More
I want to apply, to a whole column, a formula that is already an arrayformula...

arraysgoogle-sheetsstring-formattingarray-formulasgoogle-query-language

Read More
Is there a way to make a google query sum multiple columns scalable?...

arraysgoogle-sheetssumoffsetgoogle-query-language

Read More
Google Sheets formula find highest or average from different sheets based on name...

google-sheetscountmaxaveragegoogle-query-language

Read More
Google Sheets pivot data with multiple values...

google-sheetspivot-tablevlookupflattengoogle-query-language

Read More
How to Change Rows of Arrays into Opposite...

google-sheetsjoinsplitflattengoogle-query-language

Read More
Is there a way to make this query formula work? it was working before but I had to add more sheets a...

arraysgoogle-sheetsfilterarray-formulasgoogle-query-language

Read More
Why is this Query statement not displaying "text" formatted phone numbers" on Google ...

google-sheetsgoogle-sheets-formulastring-formattingsubstitutiongoogle-query-language

Read More
How to grab the last non empty row?...

if-statementgoogle-sheetsvlookupgoogle-query-languagenested-if

Read More
Google sheets copy drag formula...

google-sheetscountlimitoffsetgoogle-query-language

Read More
Using IF and WHERE ANY in Query() function...

if-statementgoogle-sheetsfiltergoogle-query-languagenested-if

Read More
How to order dates in descending order when there are multiple years in data set...

dategoogle-sheetsgoogle-sheets-formulasubstitutiongoogle-query-language

Read More
Retrieve only durations with negative numbers...

if-statementgoogle-sheetsfilterconditional-statementsgoogle-query-language

Read More
Facing a difficulty in importhtml function, using order by and select col function but header is als...

web-scrapinggoogle-sheetsxpathimportgoogle-query-language

Read More
How to SUMIF cells dated between two dates in spreadsheets...

dategoogle-sheetsspreadsheetsumifsgoogle-query-language

Read More
In google sheets how do I make a list of names based on other multiple other columns data?...

arraysgoogle-sheetsfiltercountgoogle-query-language

Read More
BackNext