14th August 2006, 11:07 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Wunfluova,
I find array formulae extremely slow and resource hungry amongst large amounts of data.
The way I do it is by sorting by A (Date) B (Track) C (Race Number) and of course the data I am trying to rank.
Then run a formulae such as :
=IF(A1&B1&C1<>A2&B2&C2,1,N1+1)
This gives you a ranking, but of course needs to be modified for dual top values, I usually use a second category such as ranking career prizemoney and the API, so the equal top ranking career prizemoney, priority goes to the horse with best API.
|