T
Terry
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:AP23,ROW($A$4:$A$51))),IF(ISNUMBER(AU23),"",""))
TIA
Terry
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:AP23,ROW($A$4:$A$51))),IF(ISNUMBER(AU23),"",""))
TIA
Terry