About 1,948,630 results (2,291 milliseconds)
Fastest Way to Read a Range of Cells into C# - BUT I want the 'text ...
https://groups.google.com/g/exceldna/c/mYPaWZWTLfY Dec 6, 2015 ... I know Interop.Range.Value2 and ExcelReference.GetValue() but both return the 'value'. In most cases I could get away with it, ...
sumproduct - find text in string
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/1WVygPPKxaU Feb 22, 2010 ... ... words into any cells within range(B37:H165) > > I need the formula to look in range(B37:H165) and find any rows containing > ... I am using Excel ...
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 AND ...
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 ... ("Select a range of cells to link", navigate to and click on, etc.) ... text within the cell or have multiple links for multiple portions of text.
Sort & filter your data - Computer - Google Docs Editors Help
https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DDesktop Right click on a cell or a range of cells, then click Create a filter. ... Type =COUNTIF(data_range, data_range)=1. Find text matching “Good” or “Great” within a ...
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en TRANSPOSE(array_or_range), Transposes the rows and columns of an array or range of cells. ... Identifies the language used in text within the specified range.
Class Range | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/range ... finder for the range, which can find and replace text in this range. deleteCells(shiftDimension), void, Deletes this range of cells. expandGroups(), Range ...
How do I automatically paste a range of cells into another tab ...
https://support.google.com/docs/thread/25986140/how-do-i-automatically-paste-a-range-of-cells-into-another-tab-preserving-the-previous-pastes?hl=en Jan 17, 2020 ... Well, my problem is not getting my data sorted with the random function. ... Then, I trigger the Sheet again by simply entering any letter or text ...
Find and Replace - finds the string but when I want it replaced it says ...
https://support.google.com/docs/thread/39815474/find-and-replace-finds-the-string-but-when-i-want-it-replaced-it-says-that-it-can-t-find-the-strin?hl=en Apr 13, 2020 ... This will convert the reference to static text, just as though you typed it into the cell. Find/Replace will work on these cells normally.
Split text, remove duplicates, or trim whitespace - Computer - Google ...
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop Split text to columns. Remove rows with repeat data. On your computer, open a spreadsheet in Google Sheets. Select the data range that you'd ...
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.
How do I filter out both blank cells and cells with specific text into a ...
https://support.google.com/docs/thread/205438279/how-do-i-filter-out-both-blank-cells-and-cells-with-specific-text-into-a-new-range-in-google-sheets?hl=en Mar 9, 2023 ... How do I filter out both blank cells and cells with specific text into a new range in google sheets? ... I also have a formula for getting rid of ...
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. I ...
How do I give someone else limited edition permission to a range of ...
https://support.google.com/docs/thread/94394078/how-do-i-give-someone-else-limited-edition-permission-to-a-range-of-cells-in-sheets?hl=en Jan 20, 2021 ... 1. Share the DOCUMENT with those who need edit rights to even a single cell on the sheet. List those users names in the Share dialog.
Reference cell data from another Google spreadsheet (not a ...
https://support.google.com/docs/thread/8274394/reference-cell-data-from-another-google-spreadsheet-not-a-different-tabbed-sheet?hl=en Jun 18, 2019 ... ... text not actual ranges/URLs. Original Poster Google user marked ... - Error: Cannot find range or sheet for imported range. Where do I ...
Navigating, pasting, formatting, and selecting tables in Google Docs ...
https://support.google.com/docs/thread/38979971/navigating-pasting-formatting-and-selecting-tables-in-google-docs?hl=en Apr 9, 2020 ... This only moved them to the left side of the cell, I could not move them up. I could not find any way to reformat the alignment within the range ...
I want to add a title to a range of cells. - Google Docs Editors ...
https://support.google.com/docs/thread/167460677/i-want-to-add-a-title-to-a-range-of-cells?hl=en Jun 15, 2022 ... ... Find the A with the bold black line underneath (used for setting the text color) and look about three icons to the right. The merge icon is ...
MATCH function - Google Docs Editors Help
https://support.google.com/docs/answer/3093378?hl=en MATCH function · VLOOKUP : Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.
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. ... COUNTBLANK : Returns the number of empty cells in a given range. COUNT : Returns ...
Can I automatically copy the cell color that has been set elsewhere ...
https://support.google.com/docs/thread/59760218/can-i-automatically-copy-the-cell-color-that-has-been-set-elsewhere-in-the-spreadsheet?hl=en Jul 18, 2020 ... I've tried conditional formatting but can't find a rule that let's me check text input (IF name exist in colomn A, change background color to ...