About 1,965,444 results (2,653 milliseconds)
How to concatenate values across 'x' multiple columns and contain ...
https://support.google.com/docs/thread/204609556/how-to-concatenate-values-across-x-multiple-columns-and-contain-specific-text?hl=en Mar 4, 2023 ... I want to concatenate select cell values for each row across each column where the header (row 1) has the text "Labels" (in orange).
How to QUERY/INDEX+MATCH multiple rows of text from a merged ...
https://support.google.com/docs/thread/11089976/how-to-query-index-match-multiple-rows-of-text-from-a-merged-cell?hl=en Aug 1, 2019 ... I've been trying multiple methods of using VLOOKUP, INDEX+MATCH, and QUERY to output 2-3 rows of information based on a drop-down merged cell.
Copy row if cells contains text - Google Docs Editors Community
https://support.google.com/docs/thread/183643120/copy-row-if-cells-contains-text?hl=en Oct 12, 2022 ... I want to automatically copy a row from one sheet to another if column D contains a specific name and column J contains part of text in the cell.
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 ... Anyway, given an Excel file like this, with 26,700 rows: And I ... row x 100 columns of numbers into a variant array using VBA .Value2 ...
Can I exclude cells from a formula based on if it's filled with a ...
https://support.google.com/docs/thread/108155120/can-i-exclude-cells-from-a-formula-based-on-if-it-s-filled-with-a-specific-color?hl=en Apr 30, 2021 ... Can I exclude cells from a formula based on if it's filled with a specific color? ... So far I manually input each bill into the row and get the ...
Filtering and removing blank rows based on text in a seperate cell ...
https://support.google.com/docs/thread/222193168/filtering-and-removing-blank-rows-based-on-text-in-a-seperate-cell?hl=en Jun 23, 2023 ... Get link. Report abuse. Filtering and removing blank rows based on text in a seperate cell. Hi There, Need some help with macro/script. I have ...
I need a script to clear certain cells in sheets when a button is ...
https://support.google.com/docs/thread/5809954/i-need-a-script-to-clear-certain-cells-in-sheets-when-a-button-is-pressed?hl=en May 9, 2019 ... so I dabbled around with all the answers posted here and could not for the life of me get the script editor to actually perform said script in ...
Google sheet macro - complete status moves row to another tab and ...
https://support.google.com/docs/thread/28381517/google-sheet-macro-complete-status-moves-row-to-another-tab-and-clears-certain-cells-in-current?hl=en Feb 11, 2020 ... I cannot find enough help or get anything to work when trying to change my excel VBA code to be java script language - like I say very new to ...
Code to move entire row to another tab based on cell value using ...
https://support.google.com/docs/thread/118114921/code-to-move-entire-row-to-another-tab-based-on-cell-value-using-google-sheets?hl=en Jul 22, 2021 ... Get link. Report abuse. Code to move entire row to ... Key words entered in the Jobs tab, column F (status), move to a particular sheet,.
Class Range | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/range ... string if the cell is empty or doesn't contain a formula. ... Returns null if the cell text direction is determined with automatic detection. // Get the text ...
I'd like to move a row to another sheet based on another cell's ...
https://support.google.com/docs/thread/115603351/i-d-like-to-move-a-row-to-another-sheet-based-on-another-cell-s-criteria?hl=en Jul 1, 2021 ... 2. I'd also like to be able to auto sort based on a conditionally formatted cell's color without changing the formulas. https://docs.google.
Must filters in Google sheets appear in row 1? - Google Docs Editors ...
https://support.google.com/docs/thread/99325436/must-filters-in-google-sheets-appear-in-row-1?hl=en Feb 22, 2021 ... My visitor may only want titles that contain text "family" among the others in the theme cell. Along with, say, "Fiction" in the Genre ...
Move Row to Bottom based on Status of cell - Google Docs Editors ...
https://support.google.com/docs/thread/146722062/move-row-to-bottom-based-on-status-of-cell?hl=en Jan 19, 2022 ... You cannot get a permanent timestamp with a spreadsheet formula, even with iterative calculation or a custom function, because formula results ...
Exclude cells from a range in COUNTIF - Google Docs Editors ...
https://support.google.com/docs/thread/243954127/exclude-cells-from-a-range-in-countif?hl=en Nov 14, 2023 ... I am trying to use a COUNTIF function to count the number of times a specific value appears in a spreadsheet. However, I want to EXCLUDE certain cells within ...
Auto Fill Text in Google Forms Spreadsheet With Value from Another ...
https://support.google.com/docs/thread/153202065/auto-fill-text-in-google-forms-spreadsheet-with-value-from-another-column-if-blank?hl=en Mar 2, 2022 ... I am somewhat tech-savvy and have done formulas in MS Excel, but am a Google formula newbie. Appreciate any help I can get! Details. Sheets ...
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 ...
Set conditional formatting to use a checkbox to change row color ...
https://support.google.com/docs/thread/189010230/set-conditional-formatting-to-use-a-checkbox-to-change-row-color-individually-throughout-the-sheet?hl=en Nov 17, 2022 ... I am attempting to set up a sheet that utilizes check boxes so that it will allow me to hit a check box and change that rows color individually.
Using a drop down list to change values in the cell next to it - Google ...
https://support.google.com/docs/thread/221341359/using-a-drop-down-list-to-change-values-in-the-cell-next-to-it?hl=en Jun 17, 2023 ... The first argument to Lambda is a name that I assign to stand-in for the value of each row. Any unreserved text string is allowed for this ...
Conditional Formatting: Getting "If cell is bold, change formatting" to ...
https://support.google.com/docs/thread/60892094/conditional-formatting-getting-if-cell-is-bold-change-formatting-to-work?hl=en Jul 24, 2020 ... I'm not sure how to word a specific condition to allow this, if there even is a way. ... CF rules are based on the value in the cell, like text or ...
Query + Importrange get specific rows of data from another sheet ...
https://support.google.com/docs/thread/269018935/query-importrange-get-specific-rows-of-data-from-another-sheet-based-on-values-on-current-sheet?hl=en Apr 12, 2024 ... So my spreadsheet will spit out 5 random numbers 1-16 in cells 'StartHere' !Z1-Z5 I want to query to return the row matching the selected number ...