Search for missing characters

[Kishan]

Using Excel 2000</SPAN></SPAN>
Hi,</SPAN></SPAN>

In the cells C6:F19 each row is filled by 3 characters 1, X or by 2, I need a formula, which can search each row and give a missing character result in the column H Note: if non of 1, X and 2 is missing I want it return "Nothing"</SPAN></SPAN>

Please see the example below</SPAN></SPAN>

Book1
	A	B	C	D	E	F	G	H	I	J
1
2
3
4
5			P1	P2	P3	P4		Not Found
6			1	1	2	1		X
7			1	1	1	1		X2
8			X	X	X	X		12
9			1	X	1	2		Nothing
10			2	2	2	2		1X
11			X	2	X	2		1
12			2	X	1	1		Nothing
13			X	1	X	X		2
14			1	X	X	1		2
15			X	2	X	1		Nothing
16			1	X	1	2		Nothing
17			1	2	1	2		X
18			1	X	X	1		2
19			1	X	X	1		2
20
21
22
Sheet1

Thank you in advance</SPAN></SPAN>

Regards,</SPAN>
Kishan</SPAN>

 

[Kishan]

You're welcome, thanks for the feedback.

Just an observation, for the Post # 6 formula, TRIM will ignore the Space if it's in the middle of the result, like in row 10

jtakw, thanks well spotted

 

[jtakw]

You're welcome, thanks again for the feedback.