Selecting Various Values for One Source

J

jazdwit07

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!
 
B

Bob Phillips

=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)
 
J

jazdwit07

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.
 
B

Bob Phillips

No, that gets the three values into separate cells.

--

HTH

Bob Phillips

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