Hi. Hope someone can help me with this. Here's what I am trying to do.
I have a list of managers and their direct reports. I would like to
select 3 of that manager's direct reports from the list. Is there a
way to do this using IF statement?
Thanks!

=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10="A",ROW($A$1 :$A$10)),1))

=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10="A",ROW($A$1 :$A$10)),2))

=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10="A",ROW($A$1 :$A$10)),3))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
ups.com...
Hi. Hope someone can help me with this. Here's what I am trying to do.
I have a list of managers and their direct reports. I would like to
select 3 of that manager's direct reports from the list. Is there a
way to do this using IF statement?
Thanks!

Thanks, Bob. Tried it but nothing happened. Please forgive my
illiteracy, but I assume that I am including all 3 strings at one time.
Is that correct? Thanks.

Bob Phillips wrote:
=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10="A",ROW($A$1 :$A$10)),1))

=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10="A",ROW($A$1 :$A$10)),2))

=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10="A",ROW($A$1 :$A$10)),3))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
ups.com...
Hi. Hope someone can help me with this. Here's what I am trying to do.
I have a list of managers and their direct reports. I would like to
select 3 of that manager's direct reports from the list. Is there a
way to do this using IF statement?
Thanks!

No, that gets the three values into separate cells.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
oups.com...

Thanks, Bob. Tried it but nothing happened. Please forgive my
illiteracy, but I assume that I am including all 3 strings at one time.
Is that correct? Thanks.

Bob Phillips wrote:
=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10="A",ROW($A$1 :$A$10)),1))

=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10="A",ROW($A$1 :$A$10)),2))

=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10="A",ROW($A$1 :$A$10)),3))

which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
ups.com...
Hi. Hope someone can help me with this. Here's what I am trying to
do.
I have a list of managers and their direct reports. I would like to
select 3 of that manager's direct reports from the list. Is there a
way to do this using IF statement?
Thanks!