SELECTION_REMOVED

[Drunkenight]

I have been receiving the following error message:-
SELECTION_REMOVED
This generally appears when I have set up a race a few hours in advance. Then by the time my robot kicks in and start betting on the race there have been a number of withdrawals to the market. I presume this error message is because my excel spreadsheet is trying to place bets on horses that have been removed. The main problem is that I get this error message against all the horses and it stops me placing any bets on that race. This seems to happen mostly on the US racing, for example the first race at Mountaineer Park. This appears to be something that has only been happening recently.

I am using ver 1.1.0.66x85n

Any help would be appreciated.

[alrodopial]

Something like the below will help

Code: Select all

=IF(A5="","";IF(RIGHT(A5,4)="(NR)","",A5))

[MiniBlueDragon]

Something like the below will help

Code: Select all

=IF(A5="","";IF(RIGHT(A5,4)="(NR)","",A5))

Lovely solution! Much better than my cobbled together one:

Code: Select all

=IF(ISERROR(FIND(" (NR)",A5,1))=TRUE,0,1)

lol

[MiniBlueDragon]

Won't let me edit my post.

Your code needs a tiny tweak from:

Code: Select all

=IF(A5="","";IF(RIGHT(A5,4)="(NR)","",A5))

To:

Code: Select all

=IF(A5="","",IF(RIGHT(A5,4)="(NR)","",A5))

[alrodopial]

The below formula for counting the actual number of runners is also good

Code: Select all

=COUNTA(A5:A45)-COUNTIF(A5:A45,"*(NR)")

[Drunkenight]

Great!! Thanks for the help. Yes I think you have the solution. I will implement it and let you know.

Thanks!

[Drunkenight]

Thanks guys!! This has worked a treat and I am no longer getting the SELECTION_REMOVED error message.