Search code examples
How to create formula to Google sheet truth table from another list?...


google-sheetsgoogle-sheets-formula

Read More
Query or filter based on ANY column in the source sheet matching a given cell...


google-sheetsgoogle-sheets-formula

Read More
How To Extract Uppercase First Letter Multiple Words Per Cells Only Ideally Ignoring First Words of ...


regexgoogle-sheetsgoogle-sheets-formula

Read More
How to arrange column data associated with dates into calendar grids (ie. 6x7 array blocks)?...


google-sheetsgoogle-sheets-formula

Read More
Google Sheet conditional format if a cell contains the same text in a row from another tab...


google-sheets-formula

Read More
Convert text to number in Google Sheets...


google-sheetsgoogle-sheets-formulagoogle-sheets-api

Read More
Extract multiple substrings of numbers of a specific length from string in Google Sheets...


regexstringgoogle-sheetssplitgoogle-sheets-formula

Read More
calculating hours based on date range...


google-sheetsgoogle-sheets-formula

Read More
Using Cell Reference in Range_String in IMPORTRANGE in Google Sheets...


google-sheetsgoogle-sheets-formula

Read More
Conditional formatting, if A2<B2 and D2<E2 on Sheet1, then cell is green on Sheet2...


google-sheetsgoogle-sheets-formula

Read More
XPath relative vs absolute tests...


xmlxpathgoogle-sheets-formula

Read More
Google Sheets IMPORTXML returns nothing from straightforward query...


xmlgoogle-sheetsgoogle-sheets-formula

Read More
How to select specific columns from array in Google Sheets query?...


google-sheetssyntaxgoogle-sheets-formulaformulagoogle-query-language

Read More
Google Sheets QUERY function - How to populate only a single cell with sum()? label doesn't work...


google-sheetsgoogle-sheets-formula

Read More
While using IMPORTXML, why can I get IMG ALT but not IMG SRC?...


google-sheets-formula

Read More
Google Sheets: Combine duplicate rows into single row keeping separate columns...


google-sheetsgoogle-sheets-formula

Read More
Add ascending numbers to words in a sentence...


google-sheetsgoogle-sheets-formula

Read More
Google Sheets formula to reference to another cell value that contains a sheet name & range...


google-sheetsgoogle-sheets-formulaformula

Read More
My QUERY+ARRAYFORMULA TEXTJOIN sheet doesn't show result as expected...


google-sheetsjoingoogle-sheets-formulagoogle-query-languagetextjoin

Read More
Google Sheets - How to sum columns in a query formula based off different drop down filters...


google-sheetsgoogle-sheets-formula

Read More
IMPORTXML returning #NA [resource at url not found] and #NA [imported content is empty] in Google sh...


google-apps-scriptgoogle-sheets-formulagoogle-sheets-api

Read More
iMPORTXML is returning #NA (imported content is empty) in some cells and #REF in some cells in Googl...


google-apps-scriptgoogle-sheetsgoogle-sheets-formula

Read More
How do I generate a tweet with cell values and conditional statements in Google Sheets?...


google-sheetsgoogle-sheets-formula

Read More
Combine a SPLIT formula with a formula that chooses N unique words from the SPLIT outcome...


google-sheetsgoogle-sheets-formula

Read More
How to make a sequence in google sheets which has increments in regular intervals...


google-sheetsgoogle-sheets-formula

Read More
Creating a randomly even distribution of two lists in google sheets...


google-sheetsgoogle-sheets-formula

Read More
Countif() if any of the comma-separated values in Sheet1(A1) appears in Sheet2(A:A)...


google-sheetsgoogle-sheets-formula

Read More
How to write a formula in Google Spreadsheet that will count sum of multiplied values using VLOOKUP ...


google-sheetsgoogle-sheets-formulavlookuptransposeflatten

Read More
Apps script conditional formatting for value not in array...


javascriptgoogle-apps-scriptgoogle-sheetsgoogle-sheets-formulaconditional-formatting

Read More
How to have a stop value to the sequence generated by SEQUENCE() function in Google Sheets...


google-sheetsgoogle-sheets-formula

Read More
BackNext