Need help creating FILTER

  • Thread starter Thread starter Beema
  • Start date Start date
B

Beema

I have a small Excel with my local football league competitions Home & Away
matches.

The format is basically
COLUMNA = DATE
COLUMNB = HOME_TEAM
COLUMNC = AWAY_TEAM

I would like to create a dropdown list on this sheet to Filter the data to
show both the home & away matches for the selected team?

The filter code would be something like (in pseudocode):

(COLUMNB="SELECTED" OR COLUMNC = "SELECTED")

where "SELECTED" = the team the person selects


Thanks for any help.
BW
 
Select the headers, do data>filter>autofilter

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
I'd like to create a dropdown which is positioned on the worksheet.

I know the AutoFilter option, but it's not what I am trying to do.
 
Why?

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Because I am distributing the Excel to people and that is the format I would
like to use.

Yes I know I could use Autofilter. But I'd rather a single-click option for
people to view a season's matches for one particular team at any time,
without having to change/edit the filter code each time...
 
If you want to filter you need a filter regardless if you like it or not,
you can have a macro
that uses an input box to select the filter criteria, apply the filter and
put the result wherever you want.


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Can I go back to my original question...

How do I create a dropdown list, which will generate the filter.

I have 20 teams in total, with 300 odd matches. I'd like a dropdown list,
which will generate and apply the filter (being like "COLUMNB =
the_selected_team OR COLUMNB = the_selected_team )
 
You can use data>validation to get a dropdown to select from, for
instruction see:

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


same site has instructions for programming autofilter as well

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top