Call out inconsistent values

Question

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

Book.xlsx

fmvizcaino · Accepted Answer

Hi @anhdo92 ,

Attached is an example showing a way to do it.

Let me know if that works for you.

Best,

Fernando Vizcaino