About 1,915,992 results (2,074 milliseconds)
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 ...
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 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 ... If the text does not contain 'pencil', an error will be returned. You can use IF() to create a logical decision on what the formula should do if ...
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 ... If cell contains "y" then text should display image inserted into cell K1 (green check mark) ... Is there a specific formula or feature that will ...
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 ... ... formula used to only occupy one cell (no helper columns). Any ideas? The ... function with check box system in lieu of your filtered list.
Formula to return if cell is blank (no visible text) vs contains formula ...
https://support.google.com/docs/thread/168620875/formula-to-return-if-cell-is-blank-no-visible-text-vs-contains-formula-value?hl=en Jun 24, 2022 ... I have a few columns, all containing a formula. The formulas in the cells will either return a "" if false, or a specific cell value if true.
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 ... Here's the test sheet: https://docs.google ... There's one function with the superpower of being able to ignore hidden cells: SUBTOTAL().
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 ...
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 ... ... search for a specific subject name even thought the ... Without ARRAYFORMULA, the sheet will only look at the first cell of the formula.
How to autofill text in the cell based on the exact text in another cell ...
https://support.google.com/docs/thread/157667730/how-to-autofill-text-in-the-cell-based-on-the-exact-text-in-another-cell?hl=en Mar 28, 2022 ... I am struggling to make my formula work. The idea to set a conditional formatting for column C when if Orderer is James (text in $B2 = "James") ...
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 do statements like: Sum all cells in range, if cell on left contains "Red" - but I can't figure out how to make that formula.
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 ...
COUNTIF - Google Docs Editors Help
https://support.google.com/docs/answer/3093480?hl=en If range contains text to check against, criterion must be a string. ... If a number is provided, each cell in range is checked for equality with criterion .
Apply two conditional formatting rules simultaneously in Google ...
https://support.google.com/docs/thread/13813522/apply-two-conditional-formatting-rules-simultaneously-in-google-sheets?hl=en Sep 7, 2019 ... I'm wanting to do something similar, but just based on cells containing specific text. My custom formula =$E2="Text" works fine but I'm ...
Multiplying based off if another cell has text... - Google Docs Editors ...
https://support.google.com/docs/thread/26967763/multiplying-based-off-if-another-cell-has-text?hl=en Jan 28, 2020 ... I'd like to have a formula that would help me multiply each type of candy based off a certain price, which is determined by whether or not another cell ...
How do use a checkbox to return text into another cell using "IF ...
https://support.google.com/docs/thread/99424400/how-do-use-a-checkbox-to-return-text-into-another-cell-using-if?hl=en Feb 23, 2021 ... When checked I want it to return text in A1; I'm not clear on the syntax I should be using in the IF formula. ... specific problems. But, 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", ...
Text Contains contents of cell above for pivot table - Google Docs ...
https://support.google.com/docs/thread/172265827/text-contains-contents-of-cell-above-for-pivot-table?hl=en Jul 24, 2022 ... I've just used the weird formulas to create the appearance of realistic looking cell contents more easily. ... Which I believe should check ...
Conditional formatting, highlight row if cell contains substring ...
https://support.google.com/docs/thread/7025381/conditional-formatting-highlight-row-if-cell-contains-substring?hl=en May 29, 2019 ... Also, is there a way to utilize the OR function in conditional format the entire row if C column contains Green Apples or Bananas? Thanks!
Conditional formatting if another sheet contains specific text ...
https://support.google.com/docs/thread/2709736/conditional-formatting-if-another-sheet-contains-specific-text?hl=en Mar 20, 2019 ... I recommend you to use Array formula in the helper it's much better - check ... cell (Check Column B:C). Best regards,. Abbas. Original Poster ...