About 1,642,379 results (5,474 milliseconds)
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Functions can be used to create formulas that manipulate data and calculate strings and numbers. ... range based on the position where a match was found in the ...
sumproduct - find text in string
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/1WVygPPKxaU Feb 22, 2010 ... I tried to write a sumproduct formula to find various text within a range ... Microsoft Excel MVP. On Monday, February 22, 2010 7:04 PM
MATCH function - Google Docs Editors Help
https://support.google.com/docs/answer/3093378?hl=en Syntax · search_key - The value to search for. For example, 42 , "Cats" , or I24 . · range - The one-dimensional array to be searched. If a range with both height ...
Class Range | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/range Creates a text finder for the range, which can find and replace text in this range. ... String[][] — A two-dimensional array of formulas in string format.
REGEXMATCH string against column/range of data - Google Docs ...
https://support.google.com/docs/thread/159773469/regexmatch-string-against-column-range-of-data?hl=en Apr 13, 2022 ... I'm trying to use REGEXMATCH to search a single column of cells. The formula works fine enough on a single cell, but when extended beyond just one it returns a ...
How do I resolve "error cannot find range or sheet for imported ...
https://support.google.com/docs/thread/11934357/how-do-i-resolve-error-cannot-find-range-or-sheet-for-imported-range?hl=en Aug 13, 2019 ... Usually the problem occurs because the name of the tab/sheet does not match what is in the formula. ... Ensure your Sheet tab is the String name ...
Find and Replace - finds the string but when I want it replaced it says ...
https://support.google.com/docs/thread/39815474/find-and-replace-finds-the-string-but-when-i-want-it-replaced-it-says-that-it-can-t-find-the-strin?hl=en Apr 13, 2020 ... ... Excel compatible freeware program. Google user. Original Poster ... Find and replace will find the text but if it's a result of a formula ...
COUNTIF - Google Docs Editors Help
https://support.google.com/docs/answer/3093480?hl=en Returns a conditional count across a range. COUNTIF Function For this same video with audio descriptions ... If range contains text to check against, criterion ...
Reference cell data from another Google spreadsheet (not a ...
https://support.google.com/docs/thread/8274394/reference-cell-data-from-another-google-spreadsheet-not-a-different-tabbed-sheet?hl=en Jun 18, 2019 ... ... find using a formula like VLOOKUP, FILTER, QUERY, MATCH, etc. If ... - Error: Cannot find range or sheet for imported range. Where do I ...
How do I search across multiple columns for a partial string of text ...
https://support.google.com/docs/thread/121705592/how-do-i-search-across-multiple-columns-for-a-partial-string-of-text?hl=en Aug 17, 2021 ... Create a formula that will search across multiple columns and look for a partial string of text and indicate either yes or no that that text is there.
What's the correct way to indicate an "endless" range? - Google ...
https://support.google.com/docs/thread/118059590/what-s-the-correct-way-to-indicate-an-endless-range?hl=en Jul 21, 2021 ... So you can't enter a row number or column value, that doesn't already exist in your sheet, for the range of the CF formula. But the CF range ...
Vlookup approximate match when the range values are not identical ...
https://support.google.com/docs/thread/186685164/vlookup-approximate-match-when-the-range-values-are-not-identical?hl=en Nov 1, 2022 ... ... (text string) using the vlookup function. However, the cells in the range to consider for the search are not matching 100%. For example, the ...
SUMIF - Google Docs Editors Help
https://support.google.com/docs/answer/3093583?hl=en criterion - The pattern or test to apply to range . If range contains text to check against, criterion must be a string. criterion can contain wildcards ...
Use FILTER Formula to Exclude Any Cells Containing Specific Text ...
https://support.google.com/docs/thread/57887789/use-filter-formula-to-exclude-any-cells-containing-specific-text-but-exact-match?hl=en Jul 8, 2020 ... Looking for a solution to use the filter formula but exclude any rows in the range where it's "C" column cells contain any text with "cert" in ...
Count percentage of completed checkboxes while skipping cells that ...
https://support.google.com/docs/thread/172696807/count-percentage-of-completed-checkboxes-while-skipping-cells-that-don-t-have-a-checkbox?hl=en Jul 26, 2022 ... I also tried to have a string of ranges that skipped all the empty cells, but that also broke the formula. Formula 2 (Bundles Tab):. I'm looking ...
Error with VLOOKUP Not Finding Matching Text - Google Docs ...
https://support.google.com/docs/thread/162106380/error-with-vlookup-not-finding-matching-text?hl=en May 2, 2022 ... I have tried converting the search range to text by adding TO_TEXT to the formula ... I see you are working on an Excel file cause of the ...
INDIRECT function is unable to reference a Named Table - Google ...
https://support.google.com/docs/thread/283710260/indirect-function-is-unable-to-reference-a-named-table?hl=en Jul 5, 2024 ... In Excel the INDIRECT function converts the text string "UK_Type ... You should name the ranges, then the formula will work as already answered by ...
Offset Function returning "Argument must be in range" error - Google ...
https://support.google.com/docs/thread/112149458/offset-function-returning-argument-must-be-in-range-error?hl=en Jun 2, 2021 ... ... find the max ... The error isn't "Argument must be in range" but "Argument must be a range." Basically, "o3" is not a range, it's a string.
Why is search function returning TRUE on FALSE values when ...
https://support.google.com/docs/thread/136537378/why-is-search-function-returning-true-on-false-values-when-searching-for-a-string-of-texts-from-list?hl=en Nov 21, 2021 ... Your formula returns true on all rows, because the range 'List of values to lookup'!A:A contains empty text strings. An empty text string will always match any ...
IMPORTRANGE - Google Docs Editors Help
https://support.google.com/docs/answer/3093340?hl=en spreadsheet_url - The URL of the spreadsheet from where data will be imported. ... range_string - A string, of the format "[sheet_name!]range" (e.g. "Sheet1!A2:B6 ...