<tbody>
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...