About 1,243,207 results (1,927 milliseconds)
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 ...
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 ... 5) Back to the cell, double clicked and selected only the second listing, "Faceplates" ... For all documents, I tried highlighting specific text ...
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 ... Every cell in the search term list has a least one of the filter terms. I made an Edtest tab that shows how to filter one word, two words, a ...
How can you extract a specific word from a list of choices from a text ...
https://support.google.com/docs/thread/173867695/how-can-you-extract-a-specific-word-from-a-list-of-choices-from-a-text-string?hl=en Aug 4, 2022 ... Kindly hover to cell I2 in the Assignments worksheet. Thank you! Basically, I am searching for a formula that will allow me to search for a ...
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 ... I am trying to use this formula to provide a filtered list of data A1 to C5 that doesn't contain the text "Cert" anywhere in the C column cells.
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 ... So lookup the text value and return it's corresponding number. The false tells vlookup that the data (G2:H) is not sorted and an exact match of ...
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. Here's a list of all the functions available in each category.
is there a formula to check if a cell contains certain text? - Google ...
https://support.google.com/docs/thread/296695635/is-there-a-formula-to-check-if-a-cell-contains-certain-text?hl=en Sep 14, 2024 ... But the dependent cell would always return the same result ("0") for all "Fix" variations (used to auto-sort an extensive list, so the items ...
If cells in range contain specific text, return cell in different range ...
https://support.google.com/docs/thread/11003543/if-cells-in-range-contain-specific-text-return-cell-in-different-range?hl=en Jul 31, 2019 ... Hi, I'm trying to figure out how to get a list of the numbers in column A only if there is certain text in column B. I tried using LOOKUP ...
IFS function using reference cell lists? - Google Docs Editors ...
https://support.google.com/docs/thread/43250260/ifs-function-using-reference-cell-lists?hl=en Apr 29, 2020 ... ... certain texts, column F will populate one of several text strings. ... It will also find the exact match in column A (0). This type of ...
How to get selected drop down list items to remove themselves from ...
https://support.google.com/docs/thread/77638549/how-to-get-selected-drop-down-list-items-to-remove-themselves-from-a-master-list-not-the-drop-list?hl=en Oct 18, 2020 ... Along with the 25 blank cells with dropdowns, I have a master list of every employees name that is simple text in cells. I'd like to have ...
Copy entire row across IF cell in a column contains specific text ...
https://support.google.com/docs/thread/105690699/copy-entire-row-across-if-cell-in-a-column-contains-specific-text?hl=en Apr 10, 2021 ... Background: The input sheet contains a download of all SKUs in production we have which lists; description, SKU number and stock quantity. The ...
In google sheets, I want to count only visible cells with specific text in ...
https://support.google.com/docs/thread/134343279/in-google-sheets-i-want-to-count-only-visible-cells-with-specific-text-in-them-please-help?hl=en Nov 7, 2021 ... I am trying to count only visible cells with unique values in them or alternatively, it would work by counting only specific text in visible cells.
Where is the list of functions that are built-in to the macro language. I ...
https://support.google.com/docs/thread/11585560/where-is-the-list-of-functions-that-are-built-in-to-the-macro-language-i-have-searched-google?hl=en Aug 9, 2019 ... I have done this in other languages (and especially in VBA for Excel) to process text strings which have odd delimiters. ... Using cell formulae I ...
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." You can find the ...
If cell contains a specific dropdown selection, select data range from ...
https://support.google.com/docs/thread/25020428/if-cell-contains-a-specific-dropdown-selection-select-data-range-from-another-sheet?hl=en Jan 8, 2020 ... I am trying to pull specific units from named ranges on another sheet. I have tried to use the Data Validation with a custom formula =IF(C2="Food and Drink", ...
When one cell gets a certain text, then another cell gets a certain ...
https://support.google.com/docs/thread/158684352/when-one-cell-gets-a-certain-text-then-another-cell-gets-a-certain-dropdown-list?hl=en Apr 5, 2022 ... When one cell gets a certain text, then another cell gets a certain dropdown list ... Tip: Read the Tips post above, then check your ...
SHEETS: How to reference the Text/Value from one cell within a ...
https://support.google.com/docs/thread/137041108/sheets-how-to-reference-the-text-value-from-one-cell-within-a-formula-of-another-cell?hl=en Nov 24, 2021 ... ... cell value changes. Within one sheet (Main), I have a list of names, each name on a different row. Within that row is a number of formulas ...
Pull data from a column if a different column contains a set of ...
https://support.google.com/docs/thread/87817748/pull-data-from-a-column-if-a-different-column-contains-a-set-of-specific-words?hl=en Dec 9, 2020 ... The date itself is a spreadsheet number. One problem with searching for text in a date is that formatting of the cell can change without ...
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. ... specific people that have chosen to attend that ...