Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
XP Home MS Ofiice 2003 First may I apologies to T. Valko(unable to send my file to him/her)...see "complex array" Now my problem: Using following formulae in a workbook for recording scores, with the aim of having a table showing RANK (where we select top for best). At present I have two people with each having a score of 23 and equal RANK (4) and I wonder if the formulae below can be altered to give me a means of seperating the two. Another criteria is number of games they have played...one has played 40 and the other 26. =IF(AND(ISNUMBER(AU23),AU23=25),SUM(LARGE(A23:AP2 3,ROW($A$4:$A$51))),IF(ISNUMBER(AU23),"","")) TIA Terry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
Can I Rank on a second criteria if the first is equal? | Excel Discussion (Misc queries) | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
sorting with RANK/VLOOKUP (problem with equal ranks) | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |