Need to compare True and False data

[sksanjeev786]

Hi Team,

I have data from A to F (taken from Excel) and H to M (taken from a PPT table) and now I would like to compare both the data
so for a few cells i am getting a "False" error though the data are the same, only "+" symbol added in the PPT file )Hto M

and i need all the true from O to T column

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
3	4%	0.4	2%	4 p	5%	2.5 r		4%	0.4	2%	+4.0 p	5%	+2.5 r		TRUE	TRUE	TRUE	FALSE	FALSE	FALSE
4	22%	-4.5	17%	7.2 p	19%	3.1		22%	-4.5	17%	+7.2 p	19%	3.1		TRUE	TRUE	TRUE	FALSE	FALSE	TRUE
5															TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
6	49%	0.6	67%	3.6	68%	0.3		49%	0.6	67%	3.6	68%	0.3		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
7	50%	4	65%	3.7	68%	0.6		50%	4	65%	3.7	68%	0.6		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
8	5%	3.8 p	11%	0.2	13%	-0.4		5%	+3.8 p	11%	0.2	13%	-0.4		TRUE	FALSE	FALSE	TRUE	TRUE	TRUE
9	37%	0.6	56%	2.2	60%	0.6		37%	0.6	56%	2.2	60%	0.6		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
10	42%	7.2 r	61%	3.6	62%	-0.1		42%	+7.2 r	61%	3.6	62%	-0.1		TRUE	FALSE	TRUE	TRUE	TRUE	TRUE
11															TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
12	83%	-4.4	85%	3.4 r	84%	0.7		83%	-4.4	85%	+3.4 r	84%	0.7		TRUE	TRUE	TRUE	FALSE	TRUE	TRUE
13	18%	1.7	17%	1.2	22%	-4.3 q		18%	1.7	17%	1.2	22%	-4.3 q		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
14	62%	-3	71%	-0.6	65%	0.2		62%	-3	71%	-0.6	65%	0.2		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
15	10%	2.6	17%	4.3 r	22%	-0.7		10%	2.6	17%	+4.3 r	22%	-0.7		TRUE	TRUE	TRUE	FALSE	TRUE	TRUE
16	6%	-2.1	8%	-1.5	9%	0.5		6%	-2.1	8%	-1.5	9%	0.5		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
Sheet2

Cell Formulas
Range	Formula
O3:O16,Q3:Q16,S3:S16	O3	=ROUND(A3,2)=H3
P3:P16,R3:R16,T3:T16	P3	=IFERROR(ROUND(B3,2)=I3,B3=I3)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O3:T16	Cell	contains an error	text	NO
O3:V16	Cell Value	contains "f"	text	NO
B3:B16,D3:D16,F3:F16	Cell Value	contains "r"	text	NO
B3:B16,D3:D16,F3:F16	Cell Value	contains "p"	text	NO
B3:B16,D3:D16,F3:F16	Cell Value	contains "q"	text	NO

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
3	0.037815	0.4	0.023684	4.0 p	0.04814	2.5 r		0.04	0.4	0.02	+4.0 p	5%	+2.5 r		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
4	0.218487	-4.5	0.165789	7.2 p	0.190372	3.1		0.22	-4.5	0.17	+7.2 p	19%	3.1		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
5															TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
6	0.487395	0.6	0.665789	3.6	0.682713	0.3		0.49	0.6	0.67	3.6	0.68	0.3		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
7	0.5	4	0.65	3.7	0.676149	0.6		0.5	4	0.65	3.7	0.68	0.6		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
8	0.046218	3.8 p	0.105263	0.2	0.131291	-0.4		0.05	+3.8 p	11%	0.2	0.13	-0.4		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
9	0.37395	0.6	0.557895	2.2	0.597374	0.6		0.37	0.6	0.56	2.2	0.6	0.6		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
10	0.415966	7.2 r	0.613158	3.6	0.619256	-0.1		0.42	+7.2 r	0.61	3.6	0.62	-0.1		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
11															TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
12	0.827731	-4.4	0.85	3.4 r	0.844639	0.7		0.83	-4.4	0.85	+3.4 r	0.84	0.7		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
13	0.180672	1.7	0.173684	1.2	0.21663	-4.3 q		0.18	1.7	0.17	1.2	0.22	-4.3 q		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
14	0.621849	-3	0.707895	-0.6	0.645514	0.2		0.62	-3	0.71	-0.6	0.65	0.2		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
15	0.10084	2.6	0.165789	4.3 r	0.218818	-0.7		0.1	2.6	0.17	+4.3 r	0.22	-0.7		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
16	0.063025	-2.1	0.078947	-1.5	0.087527	0.5		0.06	-2.1	0.08	-1.5	0.09	0.5		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
Sheet4

Cell Formulas
Range	Formula
O3:T16	O3	=IFERROR(ROUND(A3,2)=H3,ISNUMBER(SEARCH(A3,H3)))

 

[sksanjeev786]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
3	0.037815	0.4	0.023684	4.0 p	0.04814	2.5 r		0.04	0.4	0.02	+4.0 p	5%	+2.5 r		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
4	0.218487	-4.5	0.165789	7.2 p	0.190372	3.1		0.22	-4.5	0.17	+7.2 p	19%	3.1		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
5															TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
6	0.487395	0.6	0.665789	3.6	0.682713	0.3		0.49	0.6	0.67	3.6	0.68	0.3		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
7	0.5	4	0.65	3.7	0.676149	0.6		0.5	4	0.65	3.7	0.68	0.6		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
8	0.046218	3.8 p	0.105263	0.2	0.131291	-0.4		0.05	+3.8 p	11%	0.2	0.13	-0.4		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
9	0.37395	0.6	0.557895	2.2	0.597374	0.6		0.37	0.6	0.56	2.2	0.6	0.6		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
10	0.415966	7.2 r	0.613158	3.6	0.619256	-0.1		0.42	+7.2 r	0.61	3.6	0.62	-0.1		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
11															TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
12	0.827731	-4.4	0.85	3.4 r	0.844639	0.7		0.83	-4.4	0.85	+3.4 r	0.84	0.7		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
13	0.180672	1.7	0.173684	1.2	0.21663	-4.3 q		0.18	1.7	0.17	1.2	0.22	-4.3 q		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
14	0.621849	-3	0.707895	-0.6	0.645514	0.2		0.62	-3	0.71	-0.6	0.65	0.2		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
15	0.10084	2.6	0.165789	4.3 r	0.218818	-0.7		0.1	2.6	0.17	+4.3 r	0.22	-0.7		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
16	0.063025	-2.1	0.078947	-1.5	0.087527	0.5		0.06	-2.1	0.08	-1.5	0.09	0.5		TRUE	TRUE	TRUE	TRUE	TRUE	TRUE
Sheet4

Cell Formulas
Range	Formula
O3:T16	O3	=IFERROR(ROUND(A3,2)=H3,ISNUMBER(SEARCH(A3,H3)))

thank you so much

For your help on this