List unique

[Mark]

I am using EXCEL 97

I have a column iof names in a spreadsheet, some of these entries are
repeated and I want to list on a separate worksheet each unique enrty.

Can anyone assist me with some code, please?

 

[JE McGimpsey]

One way is to use an advanced filter. See Debra Dalgleish's site for
help:

http://www.contextures.com/xladvfilter01.html#ExtractWs

For code, you can record and edit a macro using her procedure.

Alternatively, see

http://cpearson.com/excel/duplicat.htm