Use a pivot table

http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards,

Peo Sjoblom

(No private emails please)


"Wally" wrote in message
...


I have a list of sales, different dates, different products.

can I make a list on another sheet of all the products sold.

ie...


bike
car
house
bike
car
tree
cat
bike


on the new sheet the list just shows

bike
car
house
tree
cat


like an auto filter, on listed on anonther sheet cells A1 to A100

Thanks

Wally