Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Recap of Data
Column A of my spreadsheet has several thousand part numbers. Column B has
the code of the customer who purchased that product. Column C has the quantity purchased. There are many records with the same part number and/or customer code. What I would like to obtain is a recap of all the data where column E would have the list of all part numbers (no duplicates!), column F the number of customers that purchased that particular product, and column G the total quantity sold. Do you have any suggestions? Thanks. -- tb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Information in Mutiple Workbooks Not Displaying in my Recap Sheet | Excel Discussion (Misc queries) | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) | |||
how do i lookup and sum from serveral wkshts to a recap sht? | Excel Worksheet Functions | |||
Recap Worksheet | Excel Worksheet Functions | |||
Create a "recap" worksheet that includes all info from all worksh. | Excel Worksheet Functions |