Call out inconsistent values

[anhdo92]

Hi,

I have this set of data that has company names and their attendance marked as Y for yes and N for no. Attendance must be consistent under the same company name. For example: if company B doesn't attend, the attendance column should be consistently N all the way through and vice versa.

What I wanna to do is to call out any row (with company name) that doesn't follow this pattern. In this case, we have company B and D are the ones that should be called out. 

Any help is very much appreciated!

Thanks

[fmvizcaino · Accepted solution]

Hi @anhdo92 ,

Attached is an example showing a way to do it.

Let me know if that works for you.

Best,

Fernando Vizcaino

[anhdo92]

Thanks a lot! @fmvizcaino   Exactly what I'm looking for