A | B | C | D | E | F | |
1 | John James | 2 | 2A | MIPA | 8XXY | =IF(B1,C1,D1 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A1,B1,C1,D1]) |
2 | John James | 2 | 2A | MIPA | 8AMN | =IF(B2,C2,D2 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A2,B2,C2,D2]) |
3 | John James | 2 | 2A | MIPA | 8NOP | =IF(B3,C3,D3 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A3,B3,C3,D3]) |
4 | John James | 2 | 2B | MIPA | 8XOP | =IF(B4,C4,D4 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A4,B4,C4,D4]) |
5 | John James | 2 | 2A | MUNX | 8JLO | =IF(B5,C5,D5 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A5,B5,C5,D5]) |
6 | 2 | 2A | MIPA | |||
7 | John James | 2 | 2A | MIPA | 8NIU | =IF(B7,C7,D7 NOT EQUAL TO B9,C9,D9 THEN [CONCATENATE,A7,B7,C7,D7]) |
8 | John James | 2 | 2A | MIPA | 8XOS | =IF(B8,C8,D8 NOT EQUAL TO B9,C9,D9 THEN [CONCATENATE,A8,B8,C8,D8]) |
9 | 2 | 2A | MIPA |
<tbody>
</tbody>
I need formula to check if B1, C1, D1 dont match or are not equal to B6,C6,D6 then CONCATENATE them to Coulmn F.
Any Help please ?