Delete Select Targets

[Dathmar]

I have a massive sheet that I have to delete spacific entries on. Here is an example of what I'm looking at:

Please Login or Register  to view this content.

What I need to do is copy the first column which is a family. Then I have to select one of each of the 0,1 (or 1,0) and a 1,1 subject. I need to get the whole row. If I can delete the odd stuff that has nothing where 1's and 0's are that would work or if I can get anything that has the 1,1 or 1,0 or 0,1 and put them on a new sheet that works too. Anything help would be better than editing 6000 enrties by hand.

Thank you

[swatsp0p]

Try Auto-Filter. You can manipulate on various content (blanks, non-blanks, custom with parameters, etc.)

Good Luck

Bruce