Determine if 3 fields don't match

[walkerj7]

I have 3 fields that are joined from 3 different data sets that contain the same type of data.  I need to identify any rows that don't match.  Also, there are some rows that have blanks/nulls so these would automatically give a false flag, and I would need to determine if the other two populated fields don't match.  See an example below where the bold rows are the ones I need to flag:

Field 1	Field 2	Field 3
ABC	ABC	ABC
	ABC	ABC
ABC	DEF	ABC
DEF	DEF	DEF
	ABC	DEF

[Qiu · Accepted solution]

@walkerj7 
We can first filter out the Empty or Null valve after a Transpose then count the distinct vale for each row.

If the distinct count is 1 then meaning all 3 fields are equal.

[caltang]

Same thought process as @Qiu ! Added the sort and browse to tidy it up.

[flying008]

Hi, @walkerj7 

FYI.

[walkerj7]

Everyone,

These results have helped me tremendously and after testing them they all worked.  Thanks for your help!

-JW

[Qiu]

@walkerj7 
Thank you for the feedback and happy to be any help.