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;

	18:00	18:30	19:00	19:30	20:00
John	IB	IB	IB
Abraham	IB	IB	IB	IB	IB
Tom	IB	IB	IB	IB	IB
Pam	IB	IB	IB

<tbody>
</tbody>

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;

	18:00	18:30	19:00	19:30	20:00
John	IB	IB	IB
Abraham	IB	IB	IB	IB	IB
Tom	IB	IB	IB	IB	IB
Pam	IB	IB	IB

<tbody>
</tbody>

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