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

     

     

GMKubala's avatar
GMKubala
Copper Contributor
Dec 09, 2020

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

adversi's avatar
adversi
Iron Contributor
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

 

 

Resources