Selecting Various Values for One Source

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)

<[email protected]> wrote in message
news:[email protected]...
> 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)
>
> <[email protected]> wrote in message
> news:[email protected]...
> > 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)

<[email protected]> wrote in message
news:[email protected]...
>
> 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)
> >
> > <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!
> > >
>