avoid duplication ..help please
 

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(IND IRECT("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

avoid duplication ..help please
 

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

Thank you
Terry
"Terry" wrote in message
...
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(IND IRECT("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