how to find all matches in an array

I have a task list that in one column lists the person primarily responsible
for it and in the 2nd column is the back up person. The 3rd column is the
task. On another sheet I want to put in someones name and bring up all tasks
they are responsible for and all the tasks they are backup for. What is an
easy way to do this.

Easiest way IMHO would be to use advanced filter

http://www.contextures.com/xladvfilter01.html

--
Regards,

Peo Sjoblom

(No private emails please)


"Greg" <Greg@discussions.microsoft.com> wrote in message
news:FA4CB596-6451-4569-81AF-24EC18C50180@microsoft.com...
>I have a task list that in one column lists the person primarily
>responsible
> for it and in the 2nd column is the back up person. The 3rd column is the
> task. On another sheet I want to put in someones name and bring up all
> tasks
> they are responsible for and all the tasks they are backup for. What is
> an
> easy way to do this.

"Peo Sjoblom" wrote:

> Easiest way IMHO would be to use advanced filter
>
> http://www.contextures.com/xladvfilter01.html
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "Greg" <Greg@discussions.microsoft.com> wrote in message
> news:FA4CB596-6451-4569-81AF-24EC18C50180@microsoft.com...
> >I have a task list that in one column lists the person primarily
> >responsible
> > for it and in the 2nd column is the back up person. The 3rd column is the
> > task. On another sheet I want to put in someones name and bring up all
> > tasks
> > they are responsible for and all the tasks they are backup for. What is
> > an
> > easy way to do this.
>
> Thanks for the suggestion - I will try it that way