About 1,281,134 results (4,600 milliseconds)
Using find in Google Sheets to find cells containing multiple words ...
https://support.google.com/docs/thread/139358037/using-find-in-google-sheets-to-find-cells-containing-multiple-words?hl=en Dec 8, 2021 ... Once again, your help is greatly appreciated! Last edited Dec 17 ... formula to build a regex of those words and show the matching rows.
Using multiple filters of "Text does not contain" - Google Docs ...
https://support.google.com/docs/thread/8668649/using-multiple-filters-of-text-does-not-contain?hl=en Jun 25, 2019 ... The idea is to filter the search terms found on sheet 1 based on the filters in sheet 2. if a search term consists of any of the filters terms it should not be ...
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.
Trying to count multiple occurrences of a list of word inside a single ...
https://support.google.com/docs/thread/107603040/trying-to-count-multiple-occurrences-of-a-list-of-word-inside-a-single-cell?hl=en Apr 26, 2021 ... ... find the formula I came up with in cell B2. https://docs.google.com ... I am using it to count words and strings in a list of sentences or phrases ...
Search and use find and replace - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/62754?hl=en&co=GENIE.Platform%3DDesktop Also search within formulas: Searches include formulas. To replace the ... Find words using regular expressions. On your computer, open a document or ...
How to QUERY/INDEX+MATCH multiple rows of text from a merged ...
https://support.google.com/docs/thread/11089976/how-to-query-index-match-multiple-rows-of-text-from-a-merged-cell?hl=en Aug 1, 2019 ... I've been trying multiple methods of using VLOOKUP, INDEX+MATCH, and QUERY to output 2-3 rows of information based on a drop-down merged cell.
Conditional Formatting to Highlight Cells Based on Multiple Values ...
https://support.google.com/docs/thread/270172798/conditional-formatting-to-highlight-cells-based-on-multiple-values?hl=en Apr 19, 2024 ... All of these values contain the words 'director' AND 'marketing' but the 'TEXT CONTAINS' conditional formatting rule would not capture them all ...
How can I search a column for multiple keywords or sentences ...
https://support.google.com/docs/thread/25609101/how-can-i-search-a-column-for-multiple-keywords-or-sentences?hl=en Jan 14, 2020 ... I want to analyze the rule text of Magic cards for certain keywords or sentences in order to atribute them to a certain category.
Update different columns based on text value of other cells. - Google ...
https://support.google.com/docs/thread/7826333/update-different-columns-based-on-text-value-of-other-cells?hl=en Jun 11, 2019 ... For example, when using our MATCH formula, we don't want to find say ... The challenge is the text is free flow so I need to look up multiple ...
Multiple Links in One Google Sheets Cell - Google Workspace ...
https://support.google.com/a/thread/45130142/multiple-links-in-one-google-sheets-cell?hl=en May 8, 2020 ... ... text within the cell or have multiple links for multiple portions of text. ... text within the formula bar, it just adds the hyperlink formula. A.
Index Match Multiple Criteria W/ Partial String Match & Value Match ...
https://support.google.com/docs/thread/145364829/index-match-multiple-criteria-w-partial-string-match-value-match?hl=en Jan 12, 2022 ... I'm having issues when using Index Match for multiple criteria. I seem to encounter issues such as "Function INDEX parameter is out of range".
Google Sheets: Find and replace/delete many values at once ...
https://support.google.com/docs/thread/125735942/google-sheets-find-and-replace-delete-many-values-at-once?hl=en Sep 13, 2021 ... I made a sample sheet and put this formula in cell G4: =FILTER(A4:B, ISERROR(MATCH(A4:A,D4:D,0))). Just copy those values and PASTE VALUES ...
Cell formula to display different text based off text in another cell ...
https://support.google.com/docs/thread/158958439/cell-formula-to-display-different-text-based-off-text-in-another-cell?hl=en Apr 7, 2022 ... I want to be able to run multiple search queries and show different results based of the query. ... Aim of this is I can write the formula once ...
How to use find+replace to replace newline (\n) with soft linebreak or ...
https://support.google.com/docs/thread/9648924/how-to-use-find-replace-to-replace-newline-n-with-soft-linebreak-or-vertical-tab-v?hl=en Jul 10, 2019 ... I am importing text from Unix and MacOS into Google Docs document and the text gets double line-spaced on paste, even with line spacing set ...
In a pivot table, trying to add multiple filter conditions to the same ...
https://support.google.com/docs/thread/114854157/in-a-pivot-table-trying-to-add-multiple-filter-conditions-to-the-same-category?hl=en Jun 25, 2021 ... ... using multiple filters. I am working on a ... Is there a custom condition formula that I can use to exclude both of these at the same time?
CountIfs Across Multiple Tabs - Google Docs Editors Community
https://support.google.com/docs/thread/6697496/countifs-across-multiple-tabs?hl=en May 23, 2019 ... For example, I would a tally of "California" and Florida", so would the formula be... ... once cell. I thought using the | as the operator ...
Alternative to using multiple nested SUBSTITUTE - Google Docs ...
https://support.google.com/docs/thread/162805656/alternative-to-using-multiple-nested-substitute?hl=en May 8, 2022 ... * @param {S2:S} search_for The text strings to search for within text_to_search. ... I used REGEXREPLACE, and then used a utility formula to build ...
Quickest way to search multiple rows/columns at once for a single ...
https://support.google.com/docs/thread/208630346/quickest-way-to-search-multiple-rows-columns-at-once-for-a-single-true-false-match?hl=en Mar 30, 2023 ... Haven't found a solution that isn't tedious, using multiple cells or multiple IF functions in the same formula. Details. Sheets,Microsoft ...
Is there a way to delete multiple blank rows all at once without doing ...
https://support.google.com/docs/thread/199083324/is-there-a-way-to-delete-multiple-blank-rows-all-at-once-without-doing-them-in-groups?hl=en Jan 26, 2023 ... I need all the blank rows to be gone. Is there a way to delete every blank row on a sheet without highlighting, right clicking and then deleting ...
Google Sheets: Creating CUSTOM RULE in conditional formatting to ...
https://support.google.com/docs/thread/204190148/google-sheets-creating-custom-rule-in-conditional-formatting-to-search-column-contents?hl=en Mar 1, 2023 ... I'm looking to find one specific word inside cells in column E, which has multiple words, and when it's found format that whole row.