Can there be a fv formula that would get the following;
1. from the horse showing 9 to 10 past performances races, show the 3rd best speed fig
& the 4th worst speed fig.
2. from the horse showing 6 to 8 past performances races ,
show the 2nd best speed fig & the 3rd worst speed fig.
3. from the horse showing 1 to 5 past performances races, show the best speed fig
& the 2nd best speed fig.
thorny

Hi Thorny,

Just for fun......

Fig1 will show the 3rd best fig for a horse with 9 or 10 starts, the 2nd best fig for a horse with 6 to 8 starts, and the best fig for a horse with 5 or less starts.

Fig2 will show the 4th worst fig for a horse with 9 or 10 starts, the 3rd worst fig for a horse with 6 to 8 starts, and the 2nd best fig for a horse with 5 or less starts.

Unfortunately, these formulas won't break ties. So, if you have a horse with 6 starts, and ran figs of 93, 87, 84, 82, 79, 79 the 3rd worst fig will be shown as 84

Fig1 =
#GREATER($hrRaces, 8) *
#hMAX("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, #hMAX("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, #hMAX("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, 10000)-1)-1) +
#GREATER($hrRaces, 5) * #LESSER($hrRaces, 9) *
#hMAX("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, #hMAX("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, 10000)-1) +
#LESSER($hrRaces, 6) *
#hMAX("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, 10000)

Fig2 =
#GREATER($hrRaces, 8) *
#hMIN("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, #hMIN("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, #hMIN("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, #hMIN("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, 10000)+1, 10000)+1, 10000)+1, 10000) +
#GREATER($hrRaces, 5) * #LESSER($hrRaces, 9) *
#hMIN("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, #hMIN("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, #hMIN("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, 10000)+1, 10000)+1, 10000) +
#LESSER($hrRaces, 6) *
#hMAX("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, #hMAX("ppSpeedFig", 0, 1000, 0, 50, 0, 0, 10, 0, 10000)-1)

W

THANKS, WIN
THAT WILL WORK
THORNY