View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terry Terry is offline
external usenet poster
 
Posts: 88
Default 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