Check incorrect fileds then CONCATENATE

[lanjapfag]

[TABLE="width: 200"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]John James [/TD]
[TD]2 [/TD]
[TD]2A [/TD]
[TD]MIPA[/TD]
[TD]8XXY [/TD]
[TD] =IF(B1,C1,D1 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A1,B1,C1,D1]) [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John James [/TD]
[TD]2[/TD]
[TD]2A[/TD]
[TD]MIPA[/TD]
[TD]8AMN[/TD]
[TD] =IF(B2,C2,D2 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A2,B2,C2,D2])[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]John James[/TD]
[TD]2[/TD]
[TD]2A[/TD]
[TD]MIPA[/TD]
[TD]8NOP[/TD]
[TD] =IF(B3,C3,D3 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A3,B3,C3,D3])[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]John James[/TD]
[TD]2[/TD]
[TD]2B[/TD]
[TD]MIPA[/TD]
[TD]8XOP[/TD]
[TD] =IF(B4,C4,D4 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A4,B4,C4,D4])[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]John James[/TD]
[TD]2[/TD]
[TD]2A[/TD]
[TD]MUNX[/TD]
[TD]8JLO[/TD]
[TD] =IF(B5,C5,D5 NOT EQUAL TO B6,C6,D6 THEN [CONCATENATE,A5,B5,C5,D5])[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]2A[/TD]
[TD]MIPA[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]John James[/TD]
[TD]2[/TD]
[TD]2A[/TD]
[TD]MIPA[/TD]
[TD]8NIU[/TD]
[TD]=IF(B7,C7,D7 NOT EQUAL TO B9,C9,D9 THEN [CONCATENATE,A7,B7,C7,D7])[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]John James[/TD]
[TD]2[/TD]
[TD]2A[/TD]
[TD]MIPA[/TD]
[TD]8XOS[/TD]
[TD]=IF(B8,C8,D8 NOT EQUAL TO B9,C9,D9 THEN [CONCATENATE,A8,B8,C8,D8])[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]2A
[/TD]
[TD]MIPA
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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 ?

 

[lanjapfag]

I don't think you can search for font color with a formula. It sounds like what you really need is some custom code to go through all the cells you are concerned with and do to them what you want. Custom code can do a lot. It can compare the values just like you want here and it can check font colors, etc etc.

Thank you for your Help !