Get results by name in Excel 2010

Posted by Tom on Super User See other posts from Super User or by Tom
Published on 2012-09-20T14:52:42Z Indexed on 2012/09/20 21:42 UTC
Read the original article Hit count: 198

Filed under:
|

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

© Super User or respective owner

Related posts about search

Related posts about excel-2010