How do I use a function to return the address of a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Ok, I see how to use the advanced filter. I would now like to know if there
is a way to set up advanced filters on different sets of data within the same
worksheet. For example, in my case I would need a separate filter for each
event (i.e. 100m, high jump, long jump, etc.)

Or is there a way to do what I just did using functions?

BTW your info was very helpful, thanks
 
I would much rather use filters also; however, I have about 15 events that need
to be individually filtered. Would I have to manually select the ranges each
time
I wanted to filter the data? It would be ideal is I could establish a filter
for each
set of data (i.e. each event). It seems though that the advanced filter has a
memory of only one set of data.
 
Actually, something you wrote in that response to the other gentleman helped
me. You wrote about using advancedfilter and macros. Well, I looked up how to
do macros and created a macro that filtered each data set individually.
Thanks.

Dave
 

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

Return a cell address 5
return the Cell address of a value 3
how do I create a cell reference from ADDRESS function return? 3
use of ADDRESS function within CELL function 4
using the =page! feature to transpose a row to column 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
use cell address 1
How do I count occurances of a specific character in a range? 1

Back
Top