About 1,537,928 results (4,221 milliseconds)
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.
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 ...
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 ... Pretty much I have a google sheet which I update every week with the latest data. What I want to do is use a formula to show specific text ...
How to autofill a cell with specific text if another cell contains that text ...
https://support.google.com/docs/thread/31476178/how-to-autofill-a-cell-with-specific-text-if-another-cell-contains-that-text-for-3-different-texts?hl=en Feb 26, 2020 ... Here is the link to a sheet with a test setup. My current formula is: =ifs(FIND("MPti",A2),"MPti",(FIND(" ...
How can I search in a cell for a word in a sentence, and if it find it ...
https://support.google.com/docs/thread/147050478/how-can-i-search-in-a-cell-for-a-word-in-a-sentence-and-if-it-find-it-then-write-a-certain-word?hl=en Jan 21, 2022 ... You can use Search() or Find(). If your search term "pencil" appears in the search text, the character number where the term was found will be returned.
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 ... You can do that to link only certain portions of text within the cell or have multiple links for multiple portions of text. Google user.
Count Cells in once column that contain certain text that also fall in a ...
https://support.google.com/docs/thread/70340966/count-cells-in-once-column-that-contain-certain-text-that-also-fall-in-a-certain-date-range-of-anoth?hl=en Sep 10, 2020 ... I have set up a time stamp formula in column B, that will stamp the date and time when the word "passed" is selected from the drop down menu in ...
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 ... The cell to test may contain variations of "Fix ...";. the result will all return the same value, so instead of entering each of many iterations ...
How to Return a Symbol or Image If a Cell Contains a Specific Text ...
https://support.google.com/docs/thread/111195094/how-to-return-a-symbol-or-image-if-a-cell-contains-a-specific-text?hl=en May 25, 2021 ... I know this is possible in excel with data validation or conditional formatting, but I can't seem to figure it out in Sheets.
Search and remove specific text in a column - Google Docs Editors ...
https://support.google.com/docs/thread/86166652 Nov 30, 2020 ... It opens up fine in Excel and shows correct values. But the same file got corrupt values when opened in Sheets. https://docs.
How do I sum values if the cell next to them contains certain text ...
https://support.google.com/docs/thread/72577613/how-do-i-sum-values-if-the-cell-next-to-them-contains-certain-text?hl=en Sep 22, 2020 ... I'm trying to sum the values of all cells that have certain text in the cell to their left. I've been scratching my hair trying to figure this out with no luck ...
Change font color of a specific text in a single cell based on another ...
https://support.google.com/docs/thread/177592464/change-font-color-of-a-specific-text-in-a-single-cell-based-on-another-cell?hl=en Sep 2, 2022 ... If I understand you correctly it is possible with a custom conditional formatting formula. Please share a sample spreadsheet that shows ...
Generate Timestamp when data in a cell is changed to specific text ...
https://support.google.com/docs/thread/89188642/generate-timestamp-when-data-in-a-cell-is-changed-to-specific-text?hl=en Dec 17, 2020 ... You may want to search the forum for a Timestamp script, I'm sure there are some posted. But if you'd like a formula based solution try this ...
I want specific values in a pie chart connected to specific Text. And i ...
https://support.google.com/docs/thread/109877503/i-want-specific-values-in-a-pie-chart-connected-to-specific-text-and-i-don-t-know-if-it-s-possible?hl=en May 15, 2021 ... ... calculations MUCH easier. This also lets you add data using a Form for easy data entry. 2) I've added a formula in cell G1 of the "Preferred ...
Formula question - Cell text dependent on 3 separate True/False ...
https://support.google.com/docs/thread/20726612/formula-question-cell-text-dependent-on-3-separate-true-false-cell-values?hl=en Nov 21, 2019 ... I have three cells that can have a value only of either TRUE or FALSE (checkbox). I would like a separate cell to display different text based on the breakdown ...
Can I select a a column in QUERY that contains specific text ...
https://support.google.com/docs/thread/138731758/can-i-select-a-a-column-in-query-that-contains-specific-text?hl=en Dec 4, 2021 ... I hope I understand what you are asking. I created a Data validation drop-down to select the location. I entered the following formula into cell ...
How to make formulas ignore a cell until there is text in it? - Google ...
https://support.google.com/docs/thread/2908739/how-to-make-formulas-ignore-a-cell-until-there-is-text-in-it?hl=en Mar 23, 2019 ... Array formulas are frequently written with clauses that check one or more cells to see if they contain content and if not do nothing. It sounds ...
Delete specific text elements from cells - Google Docs Editors ...
https://support.google.com/docs/thread/3567570/delete-specific-text-elements-from-cells?hl=en Apr 4, 2019 ... There are no short formula police here! This is what I came up with as demonstrated on the MK.Help tab... =ARRAYFORMULA(TEXTJOIN ...
Select All Columns Where Cell In Columns Contain A Word - Google ...
https://support.google.com/docs/thread/17142752/select-all-columns-where-cell-in-columns-contain-a-word?hl=en Oct 18, 2019 ... I am looking for a query formula that will allow me to select all columns (entire column) that contain a specific word within the column.
Pivot table: how to count # times specific text in Column 1 also ...
https://support.google.com/docs/thread/3069745/pivot-table-how-to-count-times-specific-text-in-column-1-also-appears-in-column-2?hl=en Mar 26, 2019 ... ... column to the very right with the COUNTIF formula: =COUNTIF(B:C,E5) where E5 refers to the cell in the pivot table with the name of the ...