summary of customers?

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

Use a pivot table

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Wally" <wtg@hotmail.com> wrote in message
news:a50hd1tah9vi2l03nsnqv0pqgn2p0ttqes@4ax.com...
>
>
> 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
>
>
>
>
>
>
>
>
>
>
>

Use a pivot table

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Wally" <wtg@hotmail.com> wrote in message
news:a50hd1tah9vi2l03nsnqv0pqgn2p0ttqes@4ax.com...
>
>
> 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
>
>
>
>
>
>
>
>
>
>
>

Use a pivot table

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Wally" <wtg@hotmail.com> wrote in message
news:a50hd1tah9vi2l03nsnqv0pqgn2p0ttqes@4ax.com...
>
>
> 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
>
>
>
>
>
>
>
>
>
>
>

Use a pivot table

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Wally" <wtg@hotmail.com> wrote in message
news:a50hd1tah9vi2l03nsnqv0pqgn2p0ttqes@4ax.com...
>
>
> 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
>
>
>
>
>
>
>
>
>
>
>