About 1,349,336 results (3,046 milliseconds)
Check if cell contains text in a list of other cells - Google Docs ...
https://support.google.com/docs/thread/6411742/check-if-cell-contains-text-in-a-list-of-other-cells?hl=en May 19, 2019 ... ... list of email providers is A2:A10. Details. Sheets,Microsoft Windows,Business. Locked. Informational notification. This question is locked and ...
Generate a list based on fill color or text color - Google Docs Editors ...
https://support.google.com/docs/thread/140833144/generate-a-list-based-on-fill-color-or-text-color?hl=en Dec 16, 2021 ... The main objective is to generate a list containing the cells that have the same color. Details. Sheets,Microsoft Windows,Personal use. Locked.
Hide Text in Dropdown List in Cell, But Display Number - Google ...
https://support.google.com/docs/thread/132381127/hide-text-in-dropdown-list-in-cell-but-display-number?hl=en Oct 26, 2021 ... I have data in a dropdown list. iS there a way to hide everything after the hyphen, or just display the numbers I the cell after an option is selected?
How to conditional format based on a list of names - Google Docs ...
https://support.google.com/docs/thread/45427579/how-to-conditional-format-based-on-a-list-of-names?hl=en May 8, 2020 ... Format cells if... Custom Formula is... Formula: =MATCH(C2,$A$2:$A,0). Format: <format of your choice>. Change the format to whatever you want ...
If string contains text from list, write matched text to cell - Google ...
https://support.google.com/docs/thread/23160947/if-string-contains-text-from-list-write-matched-text-to-cell?hl=en Dec 17, 2019 ... I'm working on a large Google spreadsheet with key phrases, strings of text, in column A. I want to search column A based on a list of keywords that live in ...
Need help counting cells with specific text within a filtered list ...
https://support.google.com/docs/thread/12826797/need-help-counting-cells-with-specific-text-within-a-filtered-list?hl=en Aug 25, 2019 ... I would like to modify this cell to count the number of cells in the list containing a specific text string. I can't figure out how to do this to the list ...
Conditional formatting if text in a given cell is not included in list ...
https://support.google.com/docs/thread/257425256/conditional-formatting-if-text-in-a-given-cell-is-not-included-in-list?hl=en Feb 6, 2024 ... Here is a sample sheet I have created, where I have manually replicated my desired outcome. Thank you. Details. Sheets,Microsoft Windows, ...
Adding a text reports about client in one cell with a list of reports ...
https://support.google.com/docs/thread/283677568/adding-a-text-reports-about-client-in-one-cell-with-a-list-of-reports?hl=en Jul 6, 2024 ... Youtube channels for (mostly Google Sheets) video tutorials: Code With Curt - YouTube · Laurence Svekis - YouTube · Learn Google Sheets & Excel ...
If cell contains text from list - Google Docs Editors Community
https://support.google.com/docs/thread/178255101/if-cell-contains-text-from-list?hl=en Sep 6, 2022 ... I am attempting to build a Google Sheet that would have the same functionality as Excel for "if cell contains text from list."
conditional formatting - when a cell contains any word from a 2nd ...
https://support.google.com/docs/thread/25078372/conditional-formatting-when-a-cell-contains-any-word-from-a-2nd-cell-that-contains-a-list-of-words?hl=en Jan 8, 2020 ... I have a list of cells (column A) that I would like to apply a color to if that cell contains any of the words listed in cell E1.
How to return a list that matches part of the contents of a cell ...
https://support.google.com/docs/thread/112509681/how-to-return-a-list-that-matches-part-of-the-contents-of-a-cell?hl=en Jun 5, 2021 ... Looking to return a list of text if part of a cell contains a specified value in another tab. So in this example, I'm pulling data from the ...
Google Sheets drop down: choose text from list, return number in cell
https://support.google.com/docs/thread/13293015/google-sheets-drop-down-choose-text-from-list-return-number-in-cell?hl=en Aug 31, 2019 ... Many of my cells already contain basic drop down lists. What I need to accomplish is to be able to use a drop down list to choose data in ...
How do I keep the text format of a cell when retrieving that cell in a ...
https://support.google.com/docs/thread/205367574/how-do-i-keep-the-text-format-of-a-cell-when-retrieving-that-cell-in-a-drop-down-list?hl=en Mar 9, 2023 ... How do I keep the text format of a cell when retrieving that cell in a drop down list? ... Sheets,Microsoft Windows,Personal use. Locked.
How can I format text to be a different color if that text does not ...
https://support.google.com/docs/thread/75260108/how-can-i-format-text-to-be-a-different-color-if-that-text-does-not-appear-in-a-list?hl=en Oct 6, 2020 ... I am trying to format text to change color if that text does not appear in a list. I know how to do conditional formatting for if the text was in the list.
Use bulleted list in Google Sheets cell - Google Docs Editors ...
https://support.google.com/docs/thread/325506907/use-bulleted-list-in-google-sheets-cell?hl=en Feb 16, 2025 ... I want to add bullets to items in a Google Sheets cell that is formatted for text. I searched "help" for "bullets" and found references to ...
help creating a formula to list the # of occurrences of unique words ...
https://support.google.com/docs/thread/124110732/help-creating-a-formula-to-list-the-of-occurrences-of-unique-words-in-a-transcript?hl=en Sep 2, 2021 ... ... cell, listed into a single column would work? SF. Details. Sheets,Microsoft Windows,Education. Locked. Informational notification. This question ...
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 ... We have a long list with several terms we would like to be excluded/included, which can't be done manually. Details. Sheets,Microsoft Windows, ...
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. ... string, and puts each fragment into a separate cell in the row.
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 ... I have been working in a master list of materials and want to navigate between specific items within one of the groupings, in this case, Jacks, Faceplates & ...
Formula to return matching value from list for a string of text - Google ...
https://support.google.com/docs/thread/135881852/formula-to-return-matching-value-from-list-for-a-string-of-text?hl=en Nov 17, 2021 ... I added the Tab title tab and entered my formula in cell D1 in the first tab in your spreadsheet. ={ "Solution" ; ArrayFormula( if( len( A2 ...