About 1,584,028 results (2,150 milliseconds)
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 ... As you did notice your spreadsheet was an Excel format and not a Google Sheets file and that is why you were having a problem. Excel formulas ...
How do I remove a large number of duplicate entries?
https://groups.google.com/g/mylifeorganized/c/LaK4bmA7DYg Apr 27, 2014 ... How do I bulk remove a large number of duplicate items? I'd think there would be a "remove duplicates" or "remove dupes" or "delete dupes" or " ...
Split text, remove duplicates, or trim whitespace - Computer - Google ...
https://support.google.com/docs/answer/6325535?hl=en&co=GENIE.Platform%3DDesktop Remove rows with repeat data · On your computer, open a spreadsheet in Google Sheets. · Select the data range that you'd like to remove duplicates in. · At the top ...
Problem using Data Validation to prevent duplicate entries in ...
https://support.google.com/docs/thread/150859914/problem-using-data-validation-to-prevent-duplicate-entries-in-google-sheets?hl=en Feb 15, 2022 ... While it does prevent new entries of duplicates, it is also highlighting two existing cells that are not duplicates and I cannot work out why.
How can I remove duplicates AND their first instances? - Google ...
https://support.google.com/docs/thread/211042262/how-can-i-remove-duplicates-and-their-first-instances?hl=en Apr 14, 2023 ... I am running into an issue, however, where I want to remove all reoccuring data, including the first instance.
Trying to duplicate an Excel process used to minimize repetitive ...
https://support.google.com/docs/thread/236471267/trying-to-duplicate-an-excel-process-used-to-minimize-repetitive-filtering-for-data-output?hl=en Sep 25, 2023 ... Edit: Part of the function with slicers in Excel is that doesn't hide rows, which allows a helper range to build the output needed. I have ...
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 ... I have a list of part numbers that are alphanumeric characters. I am trying to remove all the duplicates on each row. When using the formula =unique(L2:P2) I ...
Removing duplicates in importrange in Sheets - Google Docs ...
https://support.google.com/docs/thread/157338504/removing-duplicates-in-importrange-in-sheets?hl=en Mar 26, 2022 ... If you want to remove rows where only some of the columns match, such as when filtering out duplicate submissions by the same person, then include a COUNT of ...
Sorting in Google Sheets results in duplicated data - Google Docs ...
https://support.google.com/docs/thread/182052928/sorting-in-google-sheets-results-in-duplicated-data?hl=en Oct 2, 2022 ... I do not expect my data to be duplicated but sorted as Excel, SAS, R, SPSS sorts data. ... You shouldn't have to go delete "empty" cells for a ...
How to Remove Duplicate's From Query - Google Docs Editors ...
https://support.google.com/docs/thread/78123190/how-to-remove-duplicate-s-from-query?hl=en Oct 20, 2020 ... On the "Data" sheet I have a list of values connected to names. The Query searches that list and pulls all the names and values in a certain ...
Multiple people working on 1 sheet resulting in entries in wrong cells ...
https://support.google.com/docs/thread/2128157/multiple-people-working-on-1-sheet-resulting-in-entries-in-wrong-cells-and-mixed-up-filters?hl=en Mar 7, 2019 ... You could then delete the duplicate rows. Conditional Formatting on large data like you're will slow down the sheet. I recommend one of the ...
How to combine two google sheets into one and merge duplicate ...
https://support.google.com/docs/thread/150385917/how-to-combine-two-google-sheets-into-one-and-merge-duplicate-rows-with-conditional-formatting?hl=en Feb 11, 2022 ... ... duplicate rows with conditional formatting? I need to merge 2 google sheets and delete duplicate rows and insert new rows with new information.
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)) ...
Duplicate Form Responses / Browser generating repeated ...
https://support.google.com/docs/thread/104418993/duplicate-form-responses-browser-generating-repeated-submissions?hl=en Mar 30, 2021 ... I've just discovered the very same duplication issue, I just setup a form for events at our tennis club. About 5 duplicates out of 60 entries, ...
How to sort & edit "History.lst" file entries?
https://groups.google.com/g/comp.mail.eudora.ms-windows/c/_Yj-n9K9mXQ Nov 6, 2012 ... duplicates and get rid of old entries and so on. I opened the file with Excel 2003 but it got messy. I wanted two columns in. Excel ... one ...
How do I count up values while excluding duplicates from other ...
https://support.google.com/docs/thread/99182081/how-do-i-count-up-values-while-excluding-duplicates-from-other-ranges?hl=en Feb 22, 2021 ... And to let you check, I listed the atheletes that the formula is counting, off to the right. You can delete all of that when you've reviewed and ...
Can't figure out why the unique formula is leaving duplicate values ...
https://support.google.com/docs/thread/11174150/can-t-figure-out-why-the-unique-formula-is-leaving-duplicate-values-in-the-result?hl=en Aug 2, 2019 ... I don't know how you populated the cells but the values in C1 and C2 are not 2.3 in the 16th decimal position which is probably further out ...
Duplicated sheets don't protect ranges - Google Docs Editors ...
https://support.google.com/docs/thread/211853672/duplicated-sheets-don-t-protect-ranges?hl=en Apr 19, 2023 ... ... out what change they made that broke the file. It's just not ... cells in the spreadsheet, including protected ranges. One easy ...
removing duplicate edges
https://groups.google.com/g/cytoscape-helpdesk/c/hkQtV_xbu5c Thanks, that works fine - I was able to remove duplicates using excel 2007. ... you can use R to remove duplicated values. cor_matrix_melt = cor_matrix_melt ...
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 ... I want to create a pie chart. I am having trouble however of finding the right way to count the duplicates, but only one time.