Ok, thanks. I see how to do it. The criterion for the filter could be the
team name in coloumn 2. Then autofilter will send the data to my specified
location. I will try it. Thanks.

"Peo Sjoblom" wrote:

What is the criteria for your team?
Use that and use the advanced filter and copy to another location

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

--
Regards,

Peo Sjoblom


"ren6175" wrote in message
...
I have a list of results from the 100m dash in one column with the racers
corresponding times. The position these players finish will change with
each
meet
as will some of the competitors. I want excel to pull out and list only
the
players
from my team and place them in a separate column. Which funtions would I
use
to accomplish this and what would be the syntax. I used offset to
determine
the first person in the list, but I want excel to start with that cell on
the next
pass through and return the second racer. I thought if I could have Excel
determine the cell address of the first player then I could tell it to
start
after that cell on the next pass. Thanks