Check if Filtered Data is Identical

[stockdam]

Hi I have a large amount of data that was copied from a scanned document (OCR).

Some of the data is repeated several times (which is correct).

I want a method of filtering the data and then checking if the visible cells are all identical.

So looking at the attached file, for example if I filter on a "1" Column A and a "1" in column B then I want to check that column C contains exactly the same data (case sensitive).

The attachment is obviously very simple and the real data is much more complex but the concept is the same. when I filter the sheet.
I don't necessarily need to know which cell is different as I can manually check but I just want to know, for example, if column C contains identical data when multiple filters are used.

[Bernie Deitrick]

In D2, enter the formula

=COUNTIFS(A:A,A2,B:B,B2,C:C,C2)=COUNTIFS(A:A,A2,B:B,B2)

And copy down to match your data in A:C. Then filter to show FALSE values - those will be the rows where two or more entries in C don't match for identical values in A and B. It won't flag which is the incorrect entry since there is no logic that will tell you that.

[stockdam]

Thanks Bernie........that worked perfectly. Now I just need to apply it to a more complicated scenario but it should work.

As you said there's no easy logic to determine which cells are wrong but that's pretty simple to do manually, if not tedious. Your answer has cut out a lot of manual effort so thanks for that.

Update: worked perfectly. Some of the cells in the real data were blank so I had to add a dummy character into them. It caught a fair number of mistakes and saved me a lot of time.

[Bernie Deitrick]

Great! Thanks for letting us know that my suggestion worked for you.