Removing Duplicates without moving cells up

Hi guys,

Need a little help with the code on this one.

I have a table of data where there a duplicate values appearing that i need to get rid of (for pivot table purposes).

I tried a remove duplicate code that i found on the internet but that made the cells move up but i need them to stay static.

Any Ideas? Thanks as always.

Book1.xlsx

You don't show the code you're using so we'll just assume.
If you change "Delete" or "Delete Shift:=xlUp" to ClearContents, will that do?

hi jolivanes,

im using the line

ActiveSheet.Range("n3:o9999").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes

but the cells move up after removing the duplicates. is there a way to fix them

Hi jaslake,

i think that kinda done it. except i only need to clear the duplicates in cells N3:O9999. how can i tweak your masterpiece to achieve this?