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

#### ambepat

##### Board Regular
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.

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
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

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

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

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

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

Replies
1
Views
551
Replies
1
Views
444
Replies
1
Views
423
Replies
1
Views
374
Replies
1
Views
488

1,221,524
Messages
6,160,324
Members
451,637
Latest member
hvp2262

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back