Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping records
I have a list of clients and their associated decision makers. Each decision
maker has a unique ID. I would like to group the decision makers to the client record where the total sales is a sum of all individual sales like this: Client Name Total Sales Decision Maker1 Sales Decision Maker2 Sales Decision Maker3 Sales I need to conduct analysis on the sheet containing the clients (averages, new calculations, etc...) but only for the client. I don't care about the decision maker info and it will only inflate my numbers. Is there a way for me to write my formulas and copy them to all records but ignore the decision makers? Please ask any questions to clarify. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grouping | Excel Discussion (Misc queries) | |||
Grouping | Excel Worksheet Functions | |||
Grouping records together using a primary key style field | Excel Discussion (Misc queries) | |||
Grouping | Excel Worksheet Functions | |||
grouping | Excel Worksheet Functions |