Please refer to response to barb R - hopefully this makes it (a little)
clearer ?!

"bj" wrote:

Are you looking for the highest total score for all competitions, the highest
score in any competition or the highest score for an individual competition
seen by the team?

do you want an indication there is a tie if one is present?

"Andy M" wrote:

Table containing team names and members of teams of two and their scores in a
number of competitions. Require to return the highest scorer for each team.
Can use vlookup to return one of the records for a team though not
necessarily the team member with highest score. Can't sort the array by
descending order of points scored because the highest scorere for any given
team will not be the same in every competition. Could probably think of a
way of doing this by writing some VBA but if anyone can think of some way of
avoiding that.....all ideas welcome