Compare 2 Columns, then output a list

J

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

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top