Selecting highest and second highest valued variables.

Hi Guys,

I am trying to figure out how to do this.

I have 6 variables setup that count each win for each Trap in Greyhound racing, so I end up with something similar to this:

Var Name       Value
trap1              10
trap2              20
trap3              21
trap4              19
trap5              28
trap6              26

Now what I want to do is be able to place a bet on the 2 highest values.
I can figure out how to do it on just the higest, but the higest and second higest is more difficult.

Any solutions would be much appreciated.

Dean

Do you use Excel?
If so, it's very easy. use custom cells then use MSExcel Rank and use the result in your trigger.

Without Excel, no idea??

I'd also like to ask here if there's a sample guide on how to set this up? I was looking for a step by step one.