Remove rows based on two criteria

[paulsolar]

Hi All

I'm fine removing duplicate rows based on one criteria

Range("A:H").RemoveDuplicates Columns:=3, Header:=xlYes

But ideally I only want to remove rows where the data is duplicated for that row in column A & C elsewhere.

I hope I have explained this correctly. Been banging my head over this for hours

Any help would be appreciated

Cheers

Paul

 

[JoeMo]

The columns argument can be an array of column numbers that must be duplicated like so:
Range("A:H").RemoveDuplicates Columns:=Array(1, 3), Header:=xlYes

 

[paulsolar]

Hi Joe,

That worked brilliantly, thanks so much. I had it just didn't think to call it an array.

Cheer

Paul

 

[JoeMo]

Hi Joe,

That worked brilliantly, thanks so much. I had it just didn't think to call it an array.

Cheer

Paul

You are welcome - thanks for the reply.

 

[paulsolar]

quick question Joe

would it work with three criterion? for example Range("A:H").RemoveDuplicates Columns:=Array(1, 3, 4), Header:=xlYes

 

[JoeMo]

quick question Joe

would it work with three criterion? for example Range("A:H").RemoveDuplicates Columns:=Array(1, 3, 4), Header:=xlYes

Certainly, ....and when in doubt try it out on a copy of your worksheet.