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
search
|excel-2010
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