need to remove all data after "n"

[sksanjeev786]

Hi Team,

I want to remove all data after "n" in the below data ie. cell O4 has n so i need blank data from P4 to end column

Book1.xlsx
	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	2	3	4	5	6	7	8	9	10	11	12	13	14	15
2	Control	Exposed	Delta	Control	Exposed	Delta	Control	Exposed	Delta	0	Brand Metrics	Control	Age: 18-34 Exposed
3	896	7254
4	334	2652	2652	358	3021	3021	204	1581	1581	0	n		2652	0
5	128	787	787	97	841	841	33	311	311	38	155	155	24	122
6	771	6020	6020	125	1234	1234	0	n	896	6020	0	1234	0	0
7	19	268	268	110	1208	1208	28	417	417	67	634	634	41	401
8	30	471	471	50	552	552	16	117	117	24	225	225	111	612
9	1046	949	0	0	0	0	0	0	0	0	0	0	0	0
10	234	190	190	488	453	453	324	306	306	0	n	1046	190	0
Sheet1

Cell Formulas
Range	Formula
F1:R1	F1	=E1+1
E2:Q2	E2	=INDEX(INDIRECT("'"&$A2&$B2&"'!A1:IV45"),9,E1)
E3:R3	E3	=IFERROR(VALUE(SUBSTITUTE(INDEX(INDIRECT("'"&$A3&$B3&"'!A1:IV45"),MATCH($A$1,INDIRECT("'"&$A3&$B3&"'!A1:A45"),0),E$1),"0","")),"")
E4:E10,F5:R10	E4	=INDEX(INDIRECT("'"&$A4&$B4&"'!A1:IV45"),MATCH($A$1,INDIRECT("'"&$A4&$B4&"'!A1:A45"),0),E$1)
F4:R4	F4	=IF(E4="n","",INDEX(INDIRECT("'"&$A4&$B4&"'!A1:IV45"),MATCH($A$1,INDIRECT("'"&$A4&$B4&"'!A1:A45"),0),F$1))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E4:BP82	Cell Value	between 50 and 74.9	text	NO
E4:BP82	Cell Value	contains "n"	text	NO
E3:BP82	Cell Value	<50	text	NO

 

[Anonymous1378]

In F4, try OR($E4:E4="n") instead of E4="n"?

 

[sksanjeev786]

In F4, try OR($E4:E4="n") instead of E4="n"?

Thank you so much...