[AusRace] Excel problem - help requested

[Tony Moffat]

Sorted - thanks
 
I used =SUMPRODUCT((A1>A$1:A$24)/COUNTIF(A$1:A$24,A$1:A$24))+1
This sorts out as least to large, to reverse that change > to <
 
This allows you to view all the ranked numbers, as in 1, 222, 33,
4444,5
 
Cheers
 
Tony
 
 
Re-send
 
 
 
 
From: Tony Moffat [mailto:tonymoffat at bigpond.com
<http://ausrace.com/mailman/listinfo/racing_ausrace.com> ] 
Sent: Thursday, July 12, 2018 8:29 PM
To: 'AusRace Racing Discussion List' <racing at ausrace.com
<http://ausrace.com/mailman/listinfo/racing_ausrace.com> >
Subject: Excel problem - help requested
 
 
 
1533657143 -this is the ten run past form for Havasay (horse 6) in the
Ramornie recently. Those numbers represent the horses performance in
the class of race leading up to this run so may not accurately reflect
its performance in real time - the runs are ranked against other
runners in this race. This is a horizontal component
 
 
 
744723477272776777777777 is the comparison for all runners on their
lead up race before the Ramornie - this is a vertical component.
Havasay is the 6th horse in (the 3 here).
 
 
 
The problem occurring more often now is that the vertical component is
not ranking runners as 1 (1st here) - essentially the runner above
Havasay should be ranked 1 - it shows a two.
 
 
 
I am using the following to obtain the vertical component
=SUMPRODUCT((U65>$L$60:$L$83)/COUNTIF($L$60:$L$83,$L$60:$L$83))+1.
 
 
 
Could a excel savvy user review this and advise how to ensure the
vertical rankings appear as they should, 1 out to 9 most often,
although the poor form horses and the non-runners are shown as 7 in
this example.
 
 
 
It does apply the correct ranking most times, except if there is no
1st in the list it does not apply a first (a 1) to a runner.
 
 
 
The array is 10 columns wide and 24 rows deep.
 
 
 
Cheers
 
 
 
Tony

 



---
This email has been checked for viruses by AVG.
https://www.avg.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ausrace.com/pipermail/racing_ausrace.com/attachments/20180718/33f5034c/attachment.html>