Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplication | Excel Discussion (Misc queries) | |||
On Microsoft Excel can I avoid duplication of names on a schedule | Excel Discussion (Misc queries) | |||
Duplication | Excel Discussion (Misc queries) | |||
avoid duplication in a column in excel | Excel Discussion (Misc queries) | |||
Duplication of function | Excel Worksheet Functions |