Purging a table of unwanted items

[rbpd5015]

Ok guys I got a file with 17k records.

here is a snippit of the code. and here is the actual file

http://www.sendspace.com/file/qda3v6

These are broken into MLB baseball series since 1999. I want to remove all series less than 3 games. So in the below snip. I want to remove records


75585 STL WAS
75586 STL WAS


SO I need to find a way to do this. I was given a piece of code in a thread yesterday that helped my correct the week numbers. Maybe it can be of some help.

=IF(B2&"@"&C2=B3&"@"&C3,G3,G2)

COL A B C D
75580 WAS BAL 23-May-10 W -120 8a 7b
75581 WAS BAL 22-May-10 W -142 7b 7b
75582 WAS BAL 21-May-10 L -153 7b 7b
75583 WAS NYM 20-May-10 L -107 7b 7a
75584 WAS NYM 19-May-10 W -134 7a 7a
75585 STL WAS 18-May-10 L 237 7a 7a
75586 STL WAS 17-May-10 L 147 7a 7a
75587 COL WAS 16-May-10 L 120 7a 6b
75588 COL WAS 15-May-10 L 139 6b 6b
75588 COL WAS 15-May-10 L 139 6b 6b
75589 COL WAS 15-May-10 L 227 6b 6b
75589 COL WAS 15-May-10 L 227 6b 6b
75590 COL WAS 13-May-10 W 169 6b 6b
75591 NYM WAS 12-May-10 W 156 6a 6a
75592 NYM WAS 11-May-10 L 128 6a 6a
75593 NYM WAS 10-May-10 W 160 6a 6a

[DonkeyOte]

based on the sample - if we assume you would a series will never exceed 7 matches then given the current configuration you might try adding a further key, eg:

I2:
=IF($H2<>$H1,COUNTIF($H2:INDEX($H:$H,ROW()+6),$H2),$I1)
copied down

You can then filter on this column where value <= 3 and delete accordingly.

On an aside - if as implied your other thread has been resolved please detail as such in the thread itself (and mark as solved).