Formula to find rows containing specific value

[msdclark]

I don't know how to phrase what I am seeking well, so I apologize if this has been covered.

I receive an Excel report that has 21 columns and 400+ rows of data. One of the columns contains all the various teams in my company. For whatever reason when this report is pulled, they do not have the teams listed separately. For instance, if I turn on filtering to try to display just my particular team, the way the report is pulled it will not allow me just to pull for my team. Each filtering option is listed as follows for the teams column:
-Team1; Team 2; Team3; Team4; Team5
-Team1; Team3; Team4; Team5
-Team1; Team2; Team4; Team5

So I have to find my team's listing within each group of options and choose these filtering categories. There are 20+ teams with extremely long names so I usually accomplish this by using the find feature to search for my team and then delete any rows manually if my team isn't listed.

Is there an easier way for me to pull out just my team out of this grouped filtering list?

I'm using Excel for Mac 2011 version 14.6.2.

[Tony Valko]

Maybe you could do something like this...

Data Range

	A	B
1	-Team1; Team 2; Team3; Team4; Team5	1
2	-Team1; Team3; Team4; Team5	1
3	-Team1; Team2; Team4; Team5	1

Let's assume your team name is Team4.

This formula entered in B1 and copied down:

=COUNTIF(A1,"*Team4*")

Then you could filter on column B = 1.