Duplicates

[ctomblin]

Hi. I use a worksheet that has a long list of names, a lot of which are duplicated. Is there a formula I can use that will delete all duplicate instances of a name? So that I am left with only one copy of each name. Thanks.

 

[Joe4]

This question has been asked many times. If you do a Search on "delete duplicates", you will see many threads dealing with the issue. Here is one thread: http://www.mrexcel.com/board2/viewtopic.php?t=73294&highlight=delete+duplicates

 

[ctomblin]

Thanks, I'll get searching.

 

[Aladin Akyurek]

...Is there a formula I can use that will delete all duplicate instances of a name? So that I am left with only one copy of each name...

For a formula-based approach, see my contrib in:

http://www.mrexcel.com/board2/viewtopic.php?t=73509