avoid duplication ..help please

T

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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

large function help please? 7
Numbers column help please? 4
duplicate name help please 9
Help please 0
Sumproduct..help please 6
Results table help please 3

Top