Your example is not entirely clear... what is in a6? Are you saying a5, a6
and a7 all have abc in them? If so, are you then saying to leave the
duplicate in the lowest numbered row alone and to delete all the other
duplicates' rows?

--
Rick (MVP - Excel)


"Anna" wrote in message
...
I would like to have a macro that scan a column (i.e. column a). Under the
scanned column, the entired row of any duplicate cell will be deleted.
(i.e.
cell a5=abc, cell a6, a7=abc, row a6 and a7 will be deleted). Anyone can
give
me a big hand?
Thank you so much.