About 1,268,678 results (3,621 milliseconds)
I want to delete all rows that have a cell with a vaule of 0 - Google ...
https://support.google.com/docs/thread/59567699/i-want-to-delete-all-rows-that-have-a-cell-with-a-vaule-of-0?hl=en Jul 17, 2020 ... If this is a one-time exercise, you can then copy the results with ⌘C and paste them over the original data as values only through ⌘+Shift+V ...
Delete duplicate rows in some columns and leave data in other ...
https://support.google.com/docs/thread/130347062/delete-duplicate-rows-in-some-columns-and-leave-data-in-other-columns?hl=en Oct 11, 2021 ... I have a report that returns duplicate values and I need to delete the duplicates but now entire row. ... Excel formulas are not the same as ...
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 ... Edit: Note that if you INSERT or DELETE a column/row it will change references so that they still refer to the same cell even if both the row ...
Delete row that return "#N/A" Lookup value - Google Docs Editors ...
https://support.google.com/docs/thread/56976614/delete-row-that-return-n-a-lookup-value?hl=en Jul 3, 2020 ... I use VLOOKUP to match the Player ID from one sheet to the player name on another sheet, however it won't return values for internal team ...
How to delete duplicate and original between two columns in ...
https://support.google.com/docs/thread/138713270/how-to-delete-duplicate-and-original-between-two-columns-in-google-sheets?hl=en Dec 4, 2021 ... Alternatively, if there is a way to simply delete the duplicate cells and keep Column A values in Column A after deleting duplicates, and keep ...
Google Sheets: Find and replace/delete many values at once ...
https://support.google.com/docs/thread/125735942/google-sheets-find-and-replace-delete-many-values-at-once?hl=en Sep 13, 2021 ... In Column A I have Names and in Column B I have associated email address(es). Separately, I have a second list of contacts in the same format ( ...
Deleting rows based on a certain values - Google Docs Editors ...
https://support.google.com/docs/thread/24330792/deleting-rows-based-on-a-certain-values?hl=en Jan 1, 2020 ... This question is locked and replying has been disabled. I have the same question (6).
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 ... The final cell should include all of the names of the fish, but also remove duplicate values of the fish if they appear in multiple columns.
How do I clear the content within a range based on the value of a cell?
https://support.google.com/docs/thread/17354642/how-do-i-clear-the-content-within-a-range-based-on-the-value-of-a-cell?hl=en Oct 21, 2019 ... I'd like to type the word "RESET" into a specific cell (A1) on my administrative spreadsheet and use importrange to make "RESET" appear on ...
Help with making one column with SAME value have a different ...
https://support.google.com/docs/thread/101987902/help-with-making-one-column-with-same-value-have-a-different-outcome-based-on-another-column-s-value?hl=en Mar 12, 2021 ... Our current process is very outdated and extremely inefficient, not live, no phone access, and on an excel sheet with a tab for each day of the ...
Automatically add a number of rows based on value? - Google Docs ...
https://support.google.com/docs/thread/160017703/automatically-add-a-number-of-rows-based-on-value?hl=en Apr 15, 2022 ... Is it possible to automatically add/remove a number of rows whenever a value changes in a specific cell? In my case I'm trying to have the ...
I'm getting #ref when deleting rows. Is there a way to avoid this ...
https://support.google.com/docs/thread/84417645/i-m-getting-ref-when-deleting-rows-is-there-a-way-to-avoid-this?hl=en Nov 21, 2020 ... I'm not too familiar with excel or google sheets. ... Drag-copying would update the relative references by only one column, but the data on the ...
i am unable to delete a cell in my google sheets, i think my delete ...
https://support.google.com/docs/thread/126992640/i-am-unable-to-delete-a-cell-in-my-google-sheets-i-think-my-delete-options-arent-woking?hl=en Sep 20, 2021 ... Or does the cell empty, but then come right back with the same content? If some cells can be deleted, but not others, is it possible that those ...
How to sum up duplicate values, but only once (for pie chart ...
https://support.google.com/docs/thread/61500367/how-to-sum-up-duplicate-values-but-only-once-for-pie-chart?hl=en Jul 28, 2020 ... Now I use a COUNTIFS function, but as you will see in the example it counts the duplicates for every row (e.g. 3x Japanisch = 3 rows with the ...
Comparing blank cell with a cell containing '0' is equating to TRUE ...
https://support.google.com/docs/thread/75135122/comparing-blank-cell-with-a-cell-containing-0-is-equating-to-true-all-of-a-sudden?hl=en Oct 6, 2020 ... When I compare values in 2 cells, one containing zero, and the other ... another being blank, Excel thinks it is the same). I don't have ...
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 ... ... values, then click (Blanks) so that it is the only item checked; Click OK; Select all empty rows with your mouse, right-click, and delete ...
In a google sheet, how do I see rows that got deleted in the version ...
https://support.google.com/docs/thread/3346084/in-a-google-sheet-how-do-i-see-rows-that-got-deleted-in-the-version-history?hl=en Mar 31, 2019 ... There's a version capturing the "undo" of my delete of the value 2 row, but not one of me deleting it. Not the 1st time I deleted it and not ...
Find & delete specific cell data from a range. Remove matching ...
https://support.google.com/docs/thread/3846279/find-delete-specific-cell-data-from-a-range-remove-matching-values-in-b-b-from-a-a?hl=en Apr 9, 2019 ... I just tested it and it seems to work perfectly, deleting all the rows containing the desired values. Is yours just deleting one instance and ...
How do I clear contents in a cell but keep the formula in google ...
https://support.google.com/docs/thread/101825326/how-do-i-clear-contents-in-a-cell-but-keep-the-formula-in-google-sheets?hl=en Mar 11, 2021 ... Formulas can output values into one or more cells. When they do this, all those cells become read only and the values there can't be edited by ...
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 ... I have 2 Google Sheets. One is referencing a cell in another doc. If I add or move rows in originating doc, it messes up my data in my other sheet.