delete rows if dublicate cell value in column 2

[gus]

Another question
range(a1:h20000) has some data
I want to delete the entire row if a value in column d apears
again in other cell (row,column d)
In other words delete dublicate rows compare only the value in column d

 

[Bernie Deitrick]

gus,

Use a formula in column I: enter either formula in I1, then copy down to match your data. Sort ascending on column I and delete any
rows where I is greater than 1, and you're done.

If you want to keep the first instance but delete second, third, etc., use in I1:
=COUNTIF($D$11,D1)

If you want to keep only those that occur once and only once, use in I1:
=COUNTIF(DO,D1)

HTH,
Bernie
Excel MVP