| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many different customers in a list? | Excel Worksheet Functions | |||
| Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
| Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Linear Mode
