J
jc9972003
A B C D E F
Outbound Inbound Internal
None Specific None
Handles Avg. Active Dur Handles Avg. Active Dur. Handles Avg. Active Dur
2 2:52 7 4:10 10 1:51
4 3:51 9 2:31 5 3:45
This is what my export looks like
I would like a waty to H lookup "Outbound", "None", "Handles", "Avg, Active Dur"
and for the formula to return all the values below Handles and Avg Active Dur.
In This case it would be
Outbound Internal
Handles Avg Act Durantion Handles Avg Act Durantion
2 2:52 10 1:51
4 3:51 5 3:45
Keep in mind Oubound, Inbound, Internal cover 6 columns each
None and Specific takeup 2 columns (The way my source exports) and below that Handles and avg act duration takeup one column each.
Kinda complicated I hope someone can help me
Outbound Inbound Internal
None Specific None
Handles Avg. Active Dur Handles Avg. Active Dur. Handles Avg. Active Dur
2 2:52 7 4:10 10 1:51
4 3:51 9 2:31 5 3:45
This is what my export looks like
I would like a waty to H lookup "Outbound", "None", "Handles", "Avg, Active Dur"
and for the formula to return all the values below Handles and Avg Active Dur.
In This case it would be
Outbound Internal
Handles Avg Act Durantion Handles Avg Act Durantion
2 2:52 10 1:51
4 3:51 5 3:45
Keep in mind Oubound, Inbound, Internal cover 6 columns each
None and Specific takeup 2 columns (The way my source exports) and below that Handles and avg act duration takeup one column each.
Kinda complicated I hope someone can help me