If I have two columns like below. How do I set something up, so that I can
input a Team Name, lets say Team2 for example and then under that team name I
get a list of every player on that team. So for the example below I would
end up with.

Team2
b
c
e


CA CB
Team Players
Team1 a
Team2 b
Team2 c
Team3 d
Team2 e
Team1 f
Team3 g

Thank you in Advance!!

Hi John,

Perhaps use Excel's Autofilter tool.

Data | Filter | Autofilter

If you are not familiar with the Autofilter feature,
see Debra Dalgleish's tutorial at:

Excel -- Filters -- AutoFilter Basics
http://www.contextures.com/xlautofilter01.html



---
Regards,
Norman


"JohnHB" <(E-Mail Removed)> wrote in message
news:203706B1-1571-4F85-B856-(E-Mail Removed)...
> If I have two columns like below. How do I set something up, so that I
> can
> input a Team Name, lets say Team2 for example and then under that team
> name I
> get a list of every player on that team. So for the example below I
> would
> end up with.
>
> Team2
> b
> c
> e
>
>
> CA CB
> Team Players
> Team1 a
> Team2 b
> Team2 c
> Team3 d
> Team2 e
> Team1 f
> Team3 g
>
> Thank you in Advance!!
>
>

Why not just filter on that column (Data=>filter=>AutoFilter)

after selecting the data.

Then in the resulting dropdown, select the team you want.

--
Regards,
Tom Ogilvy



"JohnHB" wrote:

> If I have two columns like below. How do I set something up, so that I can
> input a Team Name, lets say Team2 for example and then under that team name I
> get a list of every player on that team. So for the example below I would
> end up with.
>
> Team2
> b
> c
> e
>
>
> CA CB
> Team Players
> Team1 a
> Team2 b
> Team2 c
> Team3 d
> Team2 e
> Team1 f
> Team3 g
>
> Thank you in Advance!!
>
>

First of all thanks for the quick response.


Basically I have another sheet that has a pull down list of owners, and when
I select a owner several things on the worksheet change based on that owners
name, and one of the cells that updates is that owners team name. I was
hoping that somehow that team name cell could drive the list that I need. I
tried setting that top of the autofilter cell = to that cell and it changes
to whatever is in that cell, but does not update the list. Any idea?

"Tom Ogilvy" wrote:

> Why not just filter on that column (Data=>filter=>AutoFilter)
>
> after selecting the data.
>
> Then in the resulting dropdown, select the team you want.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "JohnHB" wrote:
>
> > If I have two columns like below. How do I set something up, so that I can
> > input a Team Name, lets say Team2 for example and then under that team name I
> > get a list of every player on that team. So for the example below I would
> > end up with.
> >
> > Team2
> > b
> > c
> > e
> >
> >
> > CA CB
> > Team Players
> > Team1 a
> > Team2 b
> > Team2 c
> > Team3 d
> > Team2 e
> > Team1 f
> > Team3 g
> >
> > Thank you in Advance!!
> >
> >