Remove Duplicates from Spreadsheet

[zalik22]

Hi,

I am trying to use VB Code to remove duplicates from a spreadsheet based off a column header of "Empl ID". I want the duplicates to be deleted.

Thanks!

 

[SteveO59L]

why would you want to use code?

 

[Joe4]

Excel has a built-in "Remove Duplicates" functionality that can do this.
It can be found on the Data menu, on the "Data Tools" ribbon.

 

[zalik22]

The number of rows of data is not fixed and it is part of a macro I am building. Thanks!

 

[Joe4]

The number of rows does not need to be pre-determined. You can apply it to the whole column.
And if you use the Macro Recorder as you record yourself using this functionality, you can get most of the code you need.
Here is a cleaned-up version that removes duplicates from column M:

    Columns("M:M").RemoveDuplicates Columns:=1, Header:=xlYes

 

[zalik22]

The number of rows does not need to be pre-determined. You can apply it to the whole column.
And if you use the Macro Recorder as you record yourself using this functionality, you can get most of the code you need.
Here is a cleaned-up version that removes duplicates from column M:

    Columns("M:M").RemoveDuplicates Columns:=1, Header:=xlYes

So this basically removes duplicates based on column M? Thanks!

 

[Joe4]

So this basically removes duplicates based on column M?

Yes.

 

[zalik22]

What does the columns:=1 signify?

 

[Joe4]

That only one column is being considered when determining duplicates.
The "Remove Duplicates" functionality can take multiple columns into account, if you like (i.e. only consider a duplicates if multiple columns match).