You could probably use a sumproduct or sum(if array formula for this.

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Roy Gudgeon" wrote in message
...
I'll try my best to explain what i I want to do....

I have a databse that contains a list of times recorded by athletes over
various distances.

I would like ot be able to run a macro that compiles a report by selecting
personal best times by athletes name for the various distances. the
database
is continually added to, athletes times are constantly updated so
refencing
specific cells is not feasible.

I currently sort the database by name, distance, best time for that
distance
so I can see an athletes history but need a method to extract the best
times
for each discipline




--
thanks
Roy