List unique
 

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?

--
Mark

List unique
 

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



In article ,
"Mark" wrote:

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?