Pick Races with Formula

[easternpromise]

Hi

Is there a way i can choose horse races the are above say 6f using a formula in my excel spreadsheet.

Thanks

[mak]

place this formula in AO1
=IF(MID(A1;FIND(":";A1)+6;1)=" ";MID(A1;FIND(":";A1)+4;2);MID(A1;FIND(":";A1)+4;4))

and this one in AO2
=IF(TYPE(FIND("m";AO1))=16;LEFT(AO1;LEN(AO1)-FIND("f";AO1)+1)*1;IF(TYPE(FIND("f";AO1))=16;LEFT(AO1;LEN(AO1)-FIND("m";AO1)+1)*8;LEFT(AO1;FIND("m";AO1)-1)*8+MID(AO1;FIND("m";AO1)+1;FIND("f";AO1)-FIND("m";AO1)*1-1)))

with these 2 formulas you have the distance at furlongs

[easternpromise]

Hi

I tried using the formula below, but get an error message?

I am using Excel 2007

the first race today is Extr 9th Nov - 12.50 2m5f Nov Hrd, but the error hightlight A1 in the formula.

can you help?

[mak]

hi
try to replace ; with ,
everywhere in the formula

=IF(MID(A1,FIND(":",A1)+6,1)=" ",MID(A1,FIND(":",A1)+4,2),MID(A1,FIND(":",A1)+4,4))


=IF(TYPE(FIND("m",BT1))=16,LEFT(BT1,LEN(BT1)-FIND("f",BT1)+1)*1,IF(TYPE(FIND("f",BT1))=16,LEFT(BT1,LEN(BT1)-FIND("m",BT1)+1)*8,LEFT(BT1,FIND("m",BT1)-1)*8+MID(BT1,FIND("m",BT1)+1,FIND("f",BT1)-FIND("m",BT1)*1-1)))

[easternpromise]

perfect

Thank you !

[easternpromise]

Mak

I there a way to modify this formula so my spreadsheet can identify whether its a jump race or flat race.

Thanks

[mak]

Sorry, I don't know a way for this one..

[alrodopial]

Code: Select all

=IF(ISNUMBER(OR(SEARCH("Hrd",A1)>0,SEARCH("Chs",A1)>0)),"Jump","Flat")