Compare 2 Columns, then output a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnHB - 31 May 2007 21:06 GMT

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

Reply to this Message

Norman Jones - 31 May 2007 21:14 GMT

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

> If I have two columns like below. How do I set something up, so that I
> can
[quoted text clipped - 20 lines]
>
> Thank you in Advance!!

Reply to this Message

Tom Ogilvy - 31 May 2007 21:22 GMT

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

after selecting the data.

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

Signature

Regards,
Tom Ogilvy

> 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
[quoted text clipped - 17 lines]
>
> Thank you in Advance!!

Reply to this Message

JohnHB - 31 May 2007 21:46 GMT

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?

> Why not just filter on that column (Data=>filter=>AutoFilter)
>
[quoted text clipped - 23 lines]
> >
> > Thank you in Advance!!

Reply to this Message