delete rows if dublicate cell value in column 2

  • Thread starter Thread starter gus
  • Start date Start date
G

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
 
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$1:D1,D1)

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

HTH,
Bernie
Excel MVP
 
Back
Top