avoid duplication ..help please

[Terry]

Win XP
MS office 2002.

I have a workbook with a(MAINS) spreadsheet for bowls scores and placings,
using the following array formulae.

=IF(COUNT(B5:AW5)<25,"NQ",SUM(LARGE(B5:AW5,ROW(INDIRECT("1:25")))))

My problem is when I have two identical scores it takes the first relative
name and duplicates the score AND name, which shows in another sheet (league
table), same workbook, as follows:
=INDEX(Main!$A$4:$A$49,MATCH(D8,Main!$AZ$4:$AZ$49,0))

Is it possible to have some function to dedicate the name and score
aggregate.?

TIA
Terry

 

[Terry]

Sorry
Please ammend first formulae array in my first post:
=IF(AND(ISNUMBER(AX5),AX5>=25),SUM(LARGE(A5:AW5,ROW($A$1:$A$25))),IF(ISNUMBER(AX5),"",""))

Thank you
Terry