You can use an Advanced Filter to export a unique list of items. There
are instructions in Excel's Help, and he

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


johnT wrote:
Hello,

I believe this is probably a simple one, yet seems to
excape me at the moment.....I have a long column of names,
often repeating names on sheet1....I would to make a
shorter list on sheet2 of all the names in the column, but
only list them once.

Thanks again for all your good ideas!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html