You can use an Advanced Filter to extract the unique items in a column,
as described he

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

Crissyb wrote:
I have a long list in my data filter in my Excel file, and I really need to
print it
to use as a hard copy. Does anyone know how I can print my list I just made
in my data filter?


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