Get results by name in Excel 2010
- by Tom
I need to parse through the data below and show results like:
Mary notready=483 training=452 break=30
I have the formulas — what I'm having trouble with is: The names are first, then 7 to 10 rows of data and what I need is some kind of array that will pull 1st Break_100 under that name, even though they are in different rows.
Mary
Summary: 08:02:32
() 9/19/2012
Not_Ready_Default_Reason_Code 00:00:05
Training_3000 07:32:21
Break_1000 00:30:06
daily 9/19/2012 08:02:32
Agent: 08:02:32
Dan
Summary: 01:18:33
() 9/19/2012
Break_1000 00:34:27
Not_Ready_Default_Reason_Code 00:01:37
Personal_4000 00:42:29
daily 9/19/2012 01:18:33
Agent: 01:18:33