Forum Discussion

Sara Cross's avatar
Sara Cross
Copper Contributor
Feb 05, 2018

Excel

I have a large worksheet with 150000 rows of data addresses, i need to compare duplication's and am trying to dedupe between two columns of postcodes, one of the columns i have added in with the postcodes i wish to strip out. help have been working on this for days.

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    I am not sure what you are asking for. Can you perhaps share a sample of your data (anonymous please) and point us to what needs to be done?
    On the data tab of the ribbon there is a remove duplicates button, is that what you need perhaps?

Resources