Current unmatched odds

[Drunkenight]

Hi, I use the following formula to extract the current unmatched odds from the 'MyBets' sheet :-

=IFERROR(INDEX(MyBets!$D$2:$D$200,MATCH(VALUE(SUBSTITUTE(T5,"P","")),MyBets!$A$2:$A$200,0)),0)

However if I have a bet which is partially matched, then this formula sometimes gives me the matched odds rather than the unmatched odds. The reason for this is because it depends which order the matched odds and unmatched odds appear in the 'MyBets' sheet. To be honest I don't understand the order in which the bets appear in the 'MyBets' sheet. It seems to be random.

So two questions.
1. What formula do other people use to extract the unmatched odds on a horse from 'MyBets'
2. Any ideas how I can change the formula to only give me the unmatched odds?

Many thanks in advance for any replies.

[vanbuuts]

Use countifs instead, and reference the volume which shows if a bet is matched "F" or unmatched "U"

[vanbuuts]

Column not volume. Typing from iPad

[Drunkenight]

Hi Vanbuuts, thanks for the reply. Yes good idea. How would I use countifs to find the unmatched odds? Any examples would be fantastic.
Many thanks
Drunkenight

[Captain Sensible]

So two questions.
1. What formula do other people use to extract the unmatched odds on a horse from 'MyBets'
2. Any ideas how I can change the formula to only give me the unmatched odds?

Many thanks in advance for any replies.

I think most of us use VBA to check the status of mybets as it's a bit more control than long formulas , Gary's posted examples of extracting data from the MyBets sheets in his old green up formulas have a look at viewtopic.php?f=8&t=4659 see if it's any use.