Prev: SUMIF function not calculating from closed worksheet
Next: Text
From: Terry on 3 Mar 2010 16:17
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


From: Bernd P on 3 Mar 2010 16:23
Hello Terry,

http://sulprobil.com/html/sorting.html

Regards,
Bernd
From: Terry on 3 Mar 2010 17:58
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" <bplumhoff(a)gmail.com> wrote in message
news:493629cf-df90-42bd-ab1d-2dcd2ed50b9f(a)d27g2000yqf.googlegroups.com...
> Hello Terry,
>
> http://sulprobil.com/html/sorting.html
>
> Regards,
> Bernd


 | 
Pages: 1
Prev: SUMIF function not calculating from closed worksheet
Next: Text