Here's an example of a technique that can be used using functions although I
personally would use filters

http://tinyurl.com/cjs32

--
Regards,

Peo Sjoblom


"ren6175" wrote in message
...
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