Sort Order

[U.F.O]

Is there an easy way to sort the horse order in excel, for example if i have the order set to back prices they are not in the same order when i link it to excel.

thanks

[GaryRussell]

It's by design. You can use Excel's rank function to determine order. See http://gruss-software.co.uk/forum/viewtopic.php?t=4886 for an example.

[U.F.O]

Yeah i can see why you wouldn't want the order constantly changing in excel, just thought there maybe a option to for example to sort into price order when you first connect excell and then it would be locked it in that order.

i will try the excel sort thing thoe thanks.

[mouse]

High guys

need some help with a trigger, as searching hasn't given me the answer.
Its to do with price order, i think.

The trigger formula i want is to:
back the fav if the total price of the 2nd +3rd fav > say 11.

would really appreciate some help here, as i spent hrs searching to no avail.
I have some v basic excel trigger knowledge e.g RANK, SMALL

thanx

[Captain Sensible]

I guess the simplest way would be to have the odds for the 2nd and 3rd favs displayed in a separate column then just use sum to add them up and use that summed figure within your trigger cell

Something like this placed in column AA and copied down from AA5 would display the odds, obviously you need to add all your other criteria in the trigger to cover things like joint 3rd favs etc but it'll display the basic odds

=IF(F5>1,IF(OR(RANK(F5,$F$5:$F$41,1)=2,RANK(F5,$F$5:$F$41,1)=3),F5,""),"")

[mouse]

will give this a try captain

many thanx