About 1,265,572 results (4,256 milliseconds)
Combine phrases in multiple cells into one cell, removing duplicate ...
https://support.google.com/docs/thread/6047360/combine-phrases-in-multiple-cells-into-one-cell-removing-duplicate-phrases?hl=en May 13, 2019 ... I want to have a list that removes the duplicate instances of Black Cod. I've tried using the textjoin function, (=textjoin(", ",True,A3:D3)) ...
Is there a way to delete multiple blank rows all at once without doing ...
https://support.google.com/docs/thread/199083324/is-there-a-way-to-delete-multiple-blank-rows-all-at-once-without-doing-them-in-groups?hl=en Jan 26, 2023 ... Is there a way to delete every blank row on a sheet without highlighting, right clicking and then deleting? And only being able to do the rows ...
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 ... Even when I select the text within the formula bar, it just adds the hyperlink formula ... It seems to remove the links if there are multiple in ...
REGEX + ARRAYFORMULA to remove characters or strings using ...
https://support.google.com/docs/thread/124123583/regex-arrayformula-to-remove-characters-or-strings-using-dynamic-cell-references?hl=en Sep 2, 2021 ... ... removal into a few designated dynamic cell references (the blue-shaded cells). Ideally, this array formula would be able to remove multiple ...
Need help with a formula that has multiple criteria. I think it needs ...
https://support.google.com/docs/thread/58086012/need-help-with-a-formula-that-has-multiple-criteria-i-think-it-needs-more-than-a-if-and-function?hl=en Jul 9, 2020 ... ... calculation if there is something in the row. To get rid of the error code, make sure all of the cells in the result column are blank ...
Can I prevent down-fill from incrementing *every* cell reference in a ...
https://support.google.com/docs/thread/5225132/can-i-prevent-down-fill-from-incrementing-every-cell-reference-in-a-formula?hl=en Apr 30, 2019 ... (On some computers, you may need to hold Fn and press the function key for it to work.) Edit: Note that if you INSERT or DELETE a column/row it ...
Function to Combine Data in Multiple Cells on one Sheet to a Single ...
https://support.google.com/docs/thread/12617867/function-to-combine-data-in-multiple-cells-on-one-sheet-to-a-single-cell-on-another-sheet?hl=en Aug 23, 2019 ... I'm familiar with formulas in Excel, just not these. The first tab ... remove the extra space between 5 and pm. So to do this in an ...
How do I delete several columns using a Google Sheets script ...
https://support.google.com/docs/thread/53508440/how-do-i-delete-several-columns-using-a-google-sheets-script?hl=en Jun 14, 2020 ... I have to manually delete several columns in the master sheet. I would like to add that function into the script, to run before the script creates the new ...
Change multiple cells based on one cell - Google Docs Editors ...
https://support.google.com/docs/thread/158571517/change-multiple-cells-based-on-one-cell?hl=en Apr 5, 2022 ... But if I14=Yes then I need those cells to still calculate the number of days between dates. I tried to use an IF formula but I couldn't make it ...
[SOLVED] Copying down formulas that skip rows - Google Docs ...
https://support.google.com/docs/thread/216050474/solved-copying-down-formulas-that-skip-rows?hl=en May 16, 2023 ... I have spent the entire day trying to handle-fill formulas that skip a row to copy down several hundred rows.
How to remove unwanted spaces - Google Docs Editors Community
https://support.google.com/docs/thread/188915830/how-to-remove-unwanted-spaces?hl=en Nov 16, 2022 ... ... formula. I have tried the "TRIM" formula, but it ... For example these will remove all spaces from cell A1 (and put it in the new cell):.
Extract specific information from a cell to multiple cells - Google ...
https://support.google.com/docs/thread/117452947/extract-specific-information-from-a-cell-to-multiple-cells?hl=en Jul 16, 2021 ... This is an array formula that fills a whole column in one go. See the new Solution sheet in your sample spreadsheet for an illustration.
Two Google Sheets are linked. If I add or delete a row in my ...
https://support.google.com/docs/thread/10102201/two-google-sheets-are-linked-if-i-add-or-delete-a-row-in-my-originating-sheet-it-messes-up-formula?hl=en Jul 17, 2019 ... If I add or delete a row in my originating sheet, it messes up formula. I have 2 Google Sheets. One is referencing a cell in another doc. If I ...
Concatenate + remove duplicate data in multiple columns for every ...
https://support.google.com/docs/thread/31883940/concatenate-remove-duplicate-data-in-multiple-columns-for-every-value-that-matches-in-column-a?hl=en Feb 29, 2020 ... In your sample spreadsheet, try something like this in cell A2 of a blank sheet: = ... You will then need to copy the latter formula down and to ...
How do I delete multiple sheets at once in a workbook? - Google ...
https://support.google.com/docs/thread/3334810/how-do-i-delete-multiple-sheets-at-once-in-a-workbook?hl=en Mar 31, 2019 ... - if you are using the first version, select (activate) the cells with the sheet names that need to be removed before clicking the remove ...
Is there a remove formula for Google sheets? - Google Docs Editors ...
https://support.google.com/docs/thread/169797196/is-there-a-remove-formula-for-google-sheets?hl=en Jul 4, 2022 ... The problem comes in where I have to go in and erase the cell manually to scan them into another sheet. Is there a way where I can input a ...
Is it possible to have conditional formatting from one row auto fill to ...
https://support.google.com/docs/thread/199855791/is-it-possible-to-have-conditional-formatting-from-one-row-auto-fill-to-other-rows?hl=en Jan 31, 2023 ... I have numbers in multiple columns and I want the smallest number in each row to be automatically highlighted. The formula I have works perfectly.
[sheets] how to change a range of cells into/from absolute/relative ...
https://support.google.com/docs/thread/198884789/sheets-how-to-change-a-range-of-cells-into-from-absolute-relative-references?hl=en Jan 25, 2023 ... in fact, the F4 key in google sheets would just work IF it worked when selecting multiple cells. a down size of it is that this function shares ...
LOOKUP Multiple results matching ID with row cell values to single ...
https://support.google.com/docs/thread/41934281/lookup-multiple-results-matching-id-with-row-cell-values-to-single-cell Apr 23, 2020 ... In cell B2 I have an alternate formula which should work in excel ... get rid of the word arrayformula and add whatever syntax excel uses instead.
UNIQUE Function still displaying duplicate values from a list of ...
https://support.google.com/docs/thread/272555264/unique-function-still-displaying-duplicate-values-from-a-list-of-alphanumeric-characters?hl=en May 2, 2024 ... ... Remove duplicates, it does remove the duplicate values, but ... formula and to give the results across several columns in 1 row. Any ...