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/xlaÂ*dvfilter01.html


blstone wrote:
I have a spreadsheet with lots of data fields. In one column of data there
are several repeating titles. Is there a way to get a list of these where
each title only appears once? Then can I copy it to a new sheet as a
reference?


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