View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GUS GUS is offline
external usenet poster
 
Posts: 45
Default delete rows if dublicate cell value in column 2

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