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.
Using my method, the duplicated records are hidden, not deleted.
To totally delete the duplicates, first do the filtering as I indicated and
then select column A, copy it and paste it on another worksheet.
The new copy will not include the duplicates. If you want, you can always
take the new copy and paste it back on to the original column.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.