Hi.. I have this excel file where in there are multiple columns with name such as below
I want to get the manager's name not equal to Employee Name.. I have already did the IFS formula which will be at column G. So for Row 2, line manager would be Jean.
=IFS(A2<>F2,F2, A2<>E2, E2,A2<>D2, D2,A2<>C2, C2,A2<>B2,B2). I started the IFS from right to left. However, this is sometimes confusing as there are a lot of criteria
Is there a shorter way for the formula so that it will not be a long IFS as originally I have more than 12 managers.
THANK YOU SO MUCH!
A | B | C | D | E | F | G | |
1 | Employee Name | Manager 1 | Manager 2 | Manager 3 | Manager 4 | Manager 5 | LINE MANAGER |
2 | Sanya | Angela | Roberto | Jean | Sanya | Sanya | Jean |
3 | Marco | Angela | Roberto | Marco | Marco | Marco | Roberto |
4 | Mary | Angela | Marko | Iza | Anji | Mary | Anji |
5 | Jane | Angela | Karina | Jane | Jane | Jane | Karina |
I want to get the manager's name not equal to Employee Name.. I have already did the IFS formula which will be at column G. So for Row 2, line manager would be Jean.
=IFS(A2<>F2,F2, A2<>E2, E2,A2<>D2, D2,A2<>C2, C2,A2<>B2,B2). I started the IFS from right to left. However, this is sometimes confusing as there are a lot of criteria
Is there a shorter way for the formula so that it will not be a long IFS as originally I have more than 12 managers.
THANK YOU SO MUCH!
