Using Power Query, I was able to achieve what I believe you are looking for in seconds. I brought your file into Power Query (This is an available free download if you are running 2010 as your profile indicates.) I filtered out column R for only 1's. I then filtered Column Q for duplicates. This brought the file down to about 4400 runs from 39K. Here is the Mcode but the file is to large to upload.
Table name is "Account." If you are unfamiliar with PQ, then click on the links in my signature to learn more. It is perfect for your needs.
Bookmarks