Forum Discussion

GMKubala's avatar
GMKubala
Copper Contributor
Dec 09, 2020
Solved

Finding duplicates in a large excel sheet

I have a very large spreadsheet of approximately 316,000 rows. I have used the conditional formatting tool to help me find duplicates. My next step is to use the find tool and search for the duplicat...
excel
  • adversi's avatar
    adversi
    Dec 09, 2020

    GMKubala

    Manual input once you filter by color, you copy and paste to the last row (instead of dragging). 

    Then you can Clear the Conditional Formatting to revert the file size back to normal

     

     

adversi's avatar
adversi
Iron Contributor
Dec 09, 2020

GMKubala 

I agree with using the conditional formatting to highlight all duplicates. From there you can create a new Helper column and input a 1 for all rows that show up in the filter to make it easier to identify all rows that are duplicates.

 

1. Conditional Format

 

2. Filter by Color

 

3. Helper Column

 

GMKubala's avatar
GMKubala
Copper Contributor
Dec 09, 2020

adversi How did you get the "1" in the duplicate column?

Resources