How to select points based on multiple attributes

Discussion created by eckertda on May 4, 2011
Latest reply on May 4, 2011 by kenbuja
So here is my problem. I have a point feature class with multiple fields. All features will have values in the first field that can be the same value but can also be different. Then the second field will all have values that can be the same value but also can be different. Please keep in mind these two fields are populated with different types of values. I need to be able to select all features that in the first field have a count of more than 1 (groups of duplicates) and those groups of duplicates selected can only be selected if their values in the second field are different from eachother (unique) within the same duplicate group. This sounds confusing but hopefully someone will understand this. Really need some help on this. Thanks