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
Solved! Go to Solution.
Hi @anhdo92 ,
Attached is an example showing a way to do it.
Let me know if that works for you.
Best,
Fernando Vizcaino
Thanks a lot! @fmvizcaino Exactly what I'm looking for