Gary,

I did the trick you gave it to me, so records suppose drop down, but the
original records was 4,344, after I run it drop down to 4,399, I saw all the
duplicate name is gone, but records was not completely drop, any idea?

The gold is I want to deleted duplicated record on columnA.

Thank you for all the help

Lillian

"Gary''s Student" wrote:

Click on the first row of the list and pull-down:

Data Filter Advanced Filter OK
then select filter the records in place and check unique records only

Only the unique records will be displayed.
--
Gary''s Student - gsnu200740


"Lillian Lian" wrote:

I have big excel spread on the columnA has duplicate name, how can I run the
scripts to fix this problem.


Thank you so much


Lillian