Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split equal RANK
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split equal RANK
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split equal RANK
Thank you Bernd...I will have a look thro' it.
N.B. Most of my complex formulae are kindly presented to me via this Newsgroup, but I am sometimes unable to grasp the formulae (senior citezen non-IT trained..just hobby) Regards Terry "Bernd P" wrote in message ... Hello Terry, http://sulprobil.com/html/sorting.html Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |