Race Type

[coco999]

Hi

Using excel is it possible to filter the race type (e.e. hcap, novice or NHF)?

I only wish to place bets in certain types of race.

Any ideas?

Regards
Andy

[milfor]

With the Excel function FIND() you can check whether a string contains a substring. You can use it to decide whether the race name contains hcap.

[coco999]

Milfor

Thanks I will try that. I wanted to select races that are maiden or novice races and wanted to exclude normal hcap races.

Cheers

[Ian]

Copy this formula into a blank cell

=IF(SUM(COUNTIF(A1,{"*Nov*","*Mdn*"}))>0,"Y","N")

It will put a Y in the cell if the race description contains Nov or Mdn

[coco999]

Ian

Fantastic many thanks