Using an array formula as follows:

=SUM((A2=A:A)*(B2=B:B)*((C2<>C:C)+(D2<>D:D)))

You can count the number of inconsistencies for a given row in a 5th column. You can then use conditional formatting to highlight all rows with inconsistencies. I've attached your example back.

Note that here my array formula refers to the entire column. This works in 2007 but not 2003. For 2003, make your array formula refer only to range specified by the entire list.

--

Alain

result.PNG

Solution-Example.xls

=SUM((A2=A:A)*(B2=B:B)*((C

You can count the number of inconsistencies for a given row in a 5th column. You can then use conditional formatting to highlight all rows with inconsistencies. I've attached your example back.

Note that here my array formula refers to the entire column. This works in 2007 but not 2003. For 2003, make your array formula refer only to range specified by the entire list.

--

Alain

result.PNG

Solution-Example.xls