jg wrote:
Yes, I will need the list to always be up to date. Can you point me in
the right direction. In the mean time I'll revisit the "Advanced
Filters"

Advanced filters is not going to work. My data looks like this...

Gender Category Division
----------------------------------------------
M Novice 40 - 49
F Expert 20 - 29
F Novice 50+

etc... to 500 rows.

Ultimatelly what I need is a small table for the top 5 in each
Gender/Category/Division combination. The data changes on a weekly
basis along with the values. Some weeks, Division will be broken by 10
(20-29) other it will be broken down by 5 (20-24). So the values I use
for my top 5 categories has to by dynamic as well.

I am not afraid to do this in VB, however, I do not even know where to
begin. I have not programmed in VB in close to 8 years. Never with
Excel though.

Any help greatly appreciated.