One option: Enter each player's position into the cell you will use to
filter (e.g., pitcher, third, second). When using auto filter for the
column, select "custom". Then, use the "contains" option in the drop
down menu and type in the position (e.g., pitcher). This will return
all the rows with that as part of the position field.


--
tobriant
------------------------------------------------------------------------
tobriant's Profile: http://www.excelforum.com/member.php...o&userid=25155
View this thread: http://www.excelforum.com/showthread...hreadid=393334