Thank you both for your help. The Advanced Filter solution worked perfectly.
Louise
"Gordon" wrote:
Louise wrote:
Hi all
I have a large worksheet with Company names entered into Column A, however,
the names are duplicated and the same one can appear up to 20 times.
Is there a quick way I can ask Excel to search the column for me and leave
just one instance of each name, rather than having to delete the duplicates
manually?
Thank you.
Louise
Have a look he
http://www.cpearson.com/excel/duplic...tingDuplicates