No reply for this question for more than 7 hours. What is happening??? Really need help here guys pleaseeeeeeeee!!!!

[ambepat]

Hi guys,

I have this question and I need some help here.

Here is my table;

[TABLE="class: cms_table"]
<tbody>[TR]
[TD][/TD]
[TD]18:00[/TD]
[TD]18:30[/TD]
[TD]19:00[/TD]
[TD]19:30
[/TD]
[TD]20:00[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abraham[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB
[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[/TR]
[TR]
[TD]Pam[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Name of Agent 18:00 - 19:00 18:00 - 20:00


What I need is a formula that will give me

1) The name of the agents that is Inbound (IB) from 18:00 - 19:00?
2) The name of the agents that is Inbound (IB) from 18:00 - 20:00?


Thanks in advance for you assistance.

 

[platonic567]

What is the desired results you are hoping to achieve?

Is it below:

1) The name of the agents that is Inbound (IB) from 18:00 - 19:00? John, Abraham, Tom, Pam
2) The name of the agents that is Inbound (IB) from 18:00 - 20:00? Abraham, Tom

 

[ambepat]

Exactly. That is my desired result. Thanks for your quick response. Really appreciate it if you can help.

 

[Mike Szczesny]

Hi guys,

I have this question and I need some help here.

Here is my table;

[TABLE="class: cms_table"]
<tbody>[TR]
[TD][/TD]
[TD]18:00[/TD]
[TD]18:30[/TD]
[TD]19:00[/TD]
[TD]19:30[/TD]
[TD]20:00[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abraham[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[/TR]
[TR]
[TD]Pam[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD]IB[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Name of Agent 18:00 - 19:00 18:00 - 20:00


What I need is a formula that will give me

1) The name of the agents that is Inbound (IB) from 18:00 - 19:00?
2) The name of the agents that is Inbound (IB) from 18:00 - 20:00?


Thanks in advance for you assistance.

Hi Ambepat, Here is what I have, keeping this example simple. Assume data table range is A1:E5
Use A7 for maximum criteria threshold. Enter 20:00. For second answer use 19:00. Use A8 for formula

A8: =index($A$2:$A$5,small(if($B$2:$E$5="IB",if($B$1:$E1=$A$7,row($A$2:$A$5)-row($A$2)+1),rows($A$8:A8))) Press Cntrl+Enter copy down

 

[FDibbins]

ambepat, just ffor the record, and in reply to your thread title - the forum (and many like it) is made up of volunteers, all of whom offer help freely, as and when they can. So a little patience goes a long way

 

[ambepat]

Understood

ambepat, just ffor the record, and in reply to your thread title - the forum (and many like it) is made up of volunteers, all of whom offer help freely, as and when they can. So a little patience goes a long way