Picking Information from a list

E

eddie84

I have a list and want to pick out certain items. The list is a list of
players and the team that they play for. I want to automatically pull
them out into their own list so as to identify all players from a club.
I have spent quite a while trying to do this and have now turned to
you.

Any help greatly appreciated.
 
D

Don Guillett

If you have a column for the player and a column with the club, simply sort
by the club column or use data>autofilter.
 
G

Gord Dibben

eddie

Try Data>Filter>Autofilter.

Filter on Team(club) name.

Gord Dibben Excel MVP
 
Top