Search code examples
Moving values from one cell to another only if two separate cells match...


google-sheetsmatchgoogle-sheets-formulaarray-formulasgs-vlookup

Read More
Replacing cell specific seperator in Google Sheets - 21.06.2019 to 21/06/2019...


arraysdategoogle-sheetsarray-formulasgoogle-sheets-query

Read More
Get the last 5 results of column C or D if column A or B is equal to ___?...


if-statementgoogle-sheetsaveragearray-formulasgoogle-sheets-query

Read More
Filter row and populate...


arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query

Read More
Google Sheet how to extract a column matching with another column?...


arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup

Read More
Extract custom decimal part in Google Sheets...


arraysregexgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
Multi Dimension Index-Match...


google-sheetsmatchgoogle-sheets-formulaarray-formulasgs-vlookup

Read More
Counting number of occurrences in column?...


google-sheetsgoogle-sheets-formulaarray-formulas

Read More
Google Sheets ArrayFormula Solution for Multiplying 2 Columns, One of Which Is a Column of Lists of ...


arraysif-statementgoogle-sheetssumarray-formulas

Read More
Google Sheets, how to subtract one array from another?...


arraysgoogle-sheetssumarray-formulasgoogle-sheets-query

Read More
RegEx with Google Sheets, Matching Items With Delimiter...


regexgoogle-sheetsgoogle-sheets-formulaarray-formulastextjoin

Read More
Extracting part of a string in Google Sheets...


regexgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
Concatenate two cells together on an import query...


arraysgoogle-sheetsarray-formulasgoogle-sheets-querygoogle-query-language

Read More
Creating a dynamically sorted and filtered list from a range using a single formula in Google Sheets...


sortinggoogle-sheetsfilteringarray-formulasgoogle-sheets-query

Read More
Extracting and counting unique word frequency from a range...


google-sheetsgoogle-sheets-formulaarray-formulascountinggoogle-sheets-query

Read More
How to find which word contained within sentence...


regexgoogle-sheetsgoogle-sheets-formulaarray-formulastextjoin

Read More
How to compare Individual data to aggregate group by in Google Query (SQL)?...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querygoogle-query-language

Read More
Index with nested match does not return expected values...


google-sheetssyntaxmatcharray-formulasgs-vlookup

Read More
How to generate a payroll condition using array formula...


arraysif-statementgoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
Why is my INDEX/MATCH function returning a wrong value?...


google-sheetsmatchgoogle-sheets-formulaarray-formulasgs-vlookup

Read More
Sum values in a range of dates with a timezone in it...


dategoogle-sheetssumgoogle-sheets-formulaarray-formulas

Read More
In Google Sheets, how can one aggregate values (MAX, MIN, AVERAGE) based on the result of splitting ...


google-sheetsgoogle-sheets-formulatransposearray-formulasgoogle-sheets-query

Read More
Getting the lowest price in Google Sheets...


google-sheetsgoogle-sheets-formulaminarray-formulasgs-vlookup

Read More
Google sheet, IF cell greater than 0 True (Seems simple enough, but its not calculating)...


if-statementgoogle-sheetsstring-formattinggoogle-sheets-formulaarray-formulas

Read More
Is there a simple way to have a cell reference that is included in a formula increment vertically wh...


excelexcel-formulareferencearray-formulascell-array

Read More
Pulling a range based on one criteria...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querytextjoin

Read More
Get all the timestamp values from a range, within the past 24 hours...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querygoogle-query-language

Read More
Showing the last value from VLOOKUP...


if-statementgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup

Read More
Google Sheets query in arrayformula acting as SUMIFS...


google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-querysumifs

Read More
Google Sheets - If worked past midnight...


if-statementtimegoogle-sheetsgoogle-sheets-formulaarray-formulas

Read More
BackNext