hows to find an delete duplicate data from ms excel?

Question

I want to know how to find and delete duplicate numbers / Names /Data from MS-Excel, i have a sheet around 60 thousand data and i want to delete duplicate Numbers from same file

Answer 1

find one be one.

Answer 2

With that amount of data I would use a VBA macro to accomplish this. Sort your table by the column with the duplicate data. Then make a macro to test the value on the column where the duplicate data is and have it delete all but the first. Assuming you are working with column A and list starts on row 2:



Sub DeleteDups()

RowNum = 3 'The row after the first row of data

Do until IsEmpty("A" & RowNum)

If Range("A" & RowNum).value = Range("A" & RowNum - 1) then

Rows(RowNum & ":" & RowNum).Delete Shift:=xlUp

Else

RowNum = RowNum + 1

End If

Loop

End Sub



I would make a backup of the file and then try it. Make sure you column and rows are correct. The macro will step down your list until it reaches the end and delete all the duplicates. I have used this macro myself to clear up tremendous amounts of duplicate data. If your duplicates are in more than one column just sort the data in the column you want to compare and make sure to set the macro to look at this column. You can resort and change the macro to look at the list again if you want to check another column.

Answer 3

The easy way without using VBA or dumping it into Access is the following:

Data > Filter > Advance Filter

check the box "Unique Records only"

By default, these are unique lines without the duplicates. copy this dataset out to another sheet.

So instead of deleting duplicates, you are getting the unique. hope that is the same for you.

Answer 4

With 60 thousands records it best to use MS Access to achieve this.

Answer 5

Hello! in ms excel type your question in the search box ( right side of page) u get a list of answer's one of them u find for sure



goodluck