Compare 2 Columns, then output a list

[JohnHB]

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

 

[Norman Jones]

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

 

[Tom Ogilvy]

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

after selecting the data.

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

 

[JohnHB]

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?