Searching for duplicates across several variables, and then searching for discrepencies

[dlthomas2000]

Greetings,

In a survey of 300 respondents and 200+ answers, users have the option of completing only a portion of the survey and finishing at a later time. In such cases, the respondent's submissions are entered twice (or more if it take them that many times to complete the survey).

Is there a formula that would 1) identify duplicates between several organizational info categories (e.g., ID, email address) to see if they did in fact submit more than once, and then 2) flag if there are discrepancies in their answers (e.g., CEO salary, vacation days).

In the example provided, I purposely do not stack examples in rows next to each other, but instead mix them up because there are several org info categories so sorting really ins't an option.

Thanks!

[JeteMc]

Perhaps the following conditional formatting rules will do what you want:
1 For yellow: =COUNTIFS(A$3:A$6,A3)>1 which is applied to the ranges =$A$3:$A$6,$F$3:$F$6
2. For green:

Please Login or Register  to view this content.

Which is applied to the range: =$H$3:$K$6
Note that the formulas in O3:R6 are not needed but were left to demonstrate how the green rule works.
Let us know if you have any questions.