[Kevin Sevcik]

Honestly. I really am banning myself from checking this after this one. I'm finding pathological cases purely by accident now. However, if you are in Highest MS mode and a team gets DQ'd two rounds in a row, their Tiebreaker.. erm.. breaks. Again, I dunno if this is just OO, but I suspect not. I traced it to the Score column. If a team was DQ'd their score was set to "0". A text zero. Presumably OO atleast doesn't like comparing the two text zeroes resulting from two DQs in a row.

The new formula for MATCHDATA.M2 (pregnant women and those with heart conditions avert your eyes):

=IF(E2="X";0;IF(OR(B2=1;B2=2;B2=3);OFFSET($DISPLAY_ENTRY.Q$1:Q $65536;MATCH(C2;$DISPLAY_ENTRY.C$1:C$65536;0);0;1; 1);IF(OR(B2=4;B2=5;B2=6);OFFSET($DISPLAY_ENTRY.Q$1 :Q$65536;MATCH(C2;$DISPLAY_ENTRY.C$1:C$65536;0)+1; 0;1;1);"-")))

Change is in bold. I swear I'm going to bed now, Joe.

EDIT: I did some cursory searches for "0" on the other sheets and didn't turn anything up, so this is hopefully the only spot.

EDIT2: I forget I pasted this straight from OO. All those semicolons should be commas for those keeping score at home. Heh.