| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
two variables to get result
Hi
I have the below data, which I want to bring in a different format. Basically the data in Column 3 I want to bring back for each sales rep, however the two variables I would be using would be Sales Rep then Count Cusotmers, or Sales Rep and Sum of Fop$ 09, to get the figure in Column 3. How would I go about this? Sales Rep Data Total Sales Rep1 Count of Customers 21 Sales Rep1 Sum of FOP$ 09 42,349,912 Sales Rep1 Sum of ACT$ 08 46,217,303 Sales Rep1 Sum of ACT$ 07 48,191,043 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| TWO VARIABLES - ONE RESULT | Excel Discussion (Misc queries) | |||
| showing lookup result with multiple variables | Excel Discussion (Misc queries) | |||
| Making solver solve for different set variables and listing result | Excel Discussion (Misc queries) | |||
| 2 Conditions True, Many Variables, Return Result | Excel Worksheet Functions | |||
Threaded Mode
