View Single Post
  #5   Report Post  
 
Posts: n/a
Default

Hi T G,

Thank you for the formula. The gentleman in the previuos
post provided a link that gave me code that did the job
for me. But I will keep this formula for possible future
use. I appreciate your reply.

Take care,

Dave Y
-----Original Message-----
You may introduce a formula like the one below in a new

column.
X3=AND(A3=A2,B3=B2)
Copy the formula to all rows. This is to be applied if

your data is sorted
one. Assuming the formula is applied in Cell X3. If

returns TRUE it means,
row 2 and row 3 are duplicates. If returns false, it is

not duplicate.
Delete all the rows containing true value.

.