Hi there.
I have a helper cell that has 1's attached to a job profile number. If an employee left or was transfered I have a 2 next to that job profile number. What I am looking to do is create a helper column that will determine whether the column to the right (B) job profile has 1's and 2's.
Any idea how to do this or am I overcomplicating it?
Sorry just to be clear
A:
ABFD 1-ABFD YES
ABFD 2-ABFD Yes
ABC 1-ABC NO
CBA 1-CBA NO
I have a helper cell that has 1's attached to a job profile number. If an employee left or was transfered I have a 2 next to that job profile number. What I am looking to do is create a helper column that will determine whether the column to the right (B) job profile has 1's and 2's.
Any idea how to do this or am I overcomplicating it?
Sorry just to be clear
A:
ABFD 1-ABFD YES
ABFD 2-ABFD Yes
ABC 1-ABC NO
CBA 1-CBA NO
Last edited: