Need some help counting and comparing. I have a file that contains a parent
id, child id, and child status. I would like to find out all of the parent
ids with the children of a particular status. Below are a couple scenerios...

1) parent A has 5 children and their status is all "IP" post on worksheet 2.
2) parent B has 5 children and 2 are "IP" and 3 are "NP" then do nothing.

Any help in how to do this?

Thanks,