Search code examples
How can I compare duplicate columns, each with a range of numbers, and return error if their ranges ...

arraysgoogle-sheetsexcel-formulaflattengoogle-query-language

Read More
Filter columns and tag name that (fulfil a criteria) from different sheet into 2 column without spac...

arraysif-statementgoogle-sheetssplitgoogle-query-language

Read More
modify number from cell reference in QUERY function (Google Sheets)...

google-sheetsgoogle-sheets-formulagoogle-query-language

Read More
How do I filter view two columns OR instead of AND?...

google-sheetsfiltergoogle-sheets-formulagoogle-query-language

Read More
Google sheets sum two columns based off of different variables sorted by variables...

arraysexcel-formulasumgoogle-sheets-formulagoogle-query-language

Read More
Seeking results of multi conditions in multi data column, but each condition value is just one of ma...

arraysif-statementgoogle-sheetsrandomgoogle-query-language

Read More
Adding an index column before the query in Google Sheet formula...

arraysgoogle-sheetsgoogle-sheets-formulasequencegoogle-query-language

Read More
Sum value of col 3 based on col 1 and col 2 value...

arraysgoogle-sheetssumvlookupgoogle-query-language

Read More
Ignore blank cells after using Filter in Google Sheets...

google-sheetsfiltertransposeflattengoogle-query-language

Read More
SUMIF the row can be found on another sheet...

google-sheetssumgoogle-sheets-formulasumifsgoogle-query-language

Read More
VLOOKUP and INDIRECT, TEXT formula combination...

google-sheetsgoogle-sheets-formulastring-formattingvlookupgoogle-query-language

Read More
Excel/Sheets combine row column content and find respecting value...

arraysgoogle-sheetssplitflattengoogle-query-language

Read More
Google Spreadsheet ArrayFormula + VLookup Transformation...

google-sheetsvlookuparray-formulasflattengoogle-query-language

Read More
Google Sheets Query Function With Multiple and Blank (ignored) Criteria...

google-sheetsgoogle-sheets-formulagoogle-query-languagetextjoin

Read More
Dynamic column selection using Query in Google Sheets...

jquerygoogle-sheetsflattengoogle-query-languagesumproduct

Read More
Adding a SUM row to a query in google sheet...

arraysgoogle-sheetssumgoogle-sheets-formulagoogle-query-language

Read More
How to duplicate rows based on columns? Google sheets (only formulas please)...

google-sheetssplitspreadsheetflattengoogle-query-language

Read More
Autofil columns in one sheet from another only if columns have data AND a specific column has a spec...

arraysgoogle-sheetsfiltergoogle-sheets-formulagoogle-query-language

Read More
Google Sheets: Return cell value in a range/array based on multiple criteria (including comparison o...

arraysgoogle-sheetsfiltergoogle-sheets-formulagoogle-query-language

Read More
Dynamic data CONCATENATE inside ARRAYFORMULA in Google Sheets...

google-sheetsconcatenationarray-formulasflattengoogle-query-language

Read More
Using ArrayFormula with Query or Filter...

arraysfiltergoogle-sheets-formulaflattengoogle-query-language

Read More
How to get total number of row entry that is grouped by rows on google sheets...

arraysif-statementgoogle-sheetsvlookupgoogle-query-language

Read More
Google Sheets Query: Select A,B,E WHERE E MATCHES X OR E MATCHES Y OR E MATCHES Z...

sqlgoogle-sheetsgoogle-sheets-formulagoogle-query-language

Read More
Combine specific columns into one column in Google sheets...

arraysgoogle-sheetstransposegoogle-query-languagetextjoin

Read More
Select cell in Google Sheets where cell begins with specific character...

regexgoogle-sheetsfiltertransposegoogle-query-language

Read More
Arranging data by occurrences...

google-sheetsrangegoogle-sheets-formulaarray-formulasgoogle-query-language

Read More
Google Sheets - how can I return votes by team, sorted by the most popular votes?...

arrayssortinggoogle-sheets-formulagoogle-query-languagetextjoin

Read More
How do I take 2 columns, one for name and one for values, and spit out the unique number of amounts ...

arraysregexif-statementgoogle-sheetsgoogle-query-language

Read More
Is there an easy way to find multiple header columns given a set of data?...

arraysgoogle-sheetsgoogle-sheets-formulatransposegoogle-query-language

Read More
how to reference data of query in a specific cell...

google-sheetsgoogle-query-language

Read More
BackNext