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" 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 |
All times are GMT +1. The time now is 04:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com