| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
group of values with the same
I have a list in the format
Floor manager; Team manager; Agent; Stat 1;stat 2 ... FM1; TM1; A1; 1% ; 1%... FM1; TM1; A2: 1% ; 1% ... FM1; Tm2; A3; 1% ; 1% FM1; TM2; A4; 1%; 1% I need to extract for a specific Tm each agent and their stats in the format TM: Agent 1; STAT1; Stat2 Agent 2; Stat1; Stat2 With each TM having his own sheet. There are randomly sized teams, and no consistant number of teams to a ccm. Can anyone suggest a way to automate extraction? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Group values | Excel Worksheet Functions | |||
| sum values in a data group | Excel Worksheet Functions | |||
| Group values and sum using loop | Excel Programming | |||
| zeroing cell values in a collapsed group | Excel Programming | |||
| Count each group of values | Excel Programming | |||
Threaded Mode
