Picking Information from a list

  • Thread starter Thread starter eddie84
  • Start date Start date
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.
 
If you have a column for the player and a column with the club, simply sort
by the club column or use data>autofilter.
 
eddie

Try Data>Filter>Autofilter.

Filter on Team(club) name.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Pick list width 4
Picking Information from a list 2
Pick List Problem 7
pick multiple items in data validation 2
Problem with Pick List associated cell 2
Pick List - Shorten KeyStrokes 1
Data-Validation -List - Pick from a drop down menu 4

Back
Top