Replace Zero in cell and show blank in amount columns

[RAJESH1960]

Hello guys

When I run the macro, cell M3 & O3 automatically are replaced by data. After I run the macro, and if there are say 10 rows of entries, the 11th and 12th row will display 0 is all the amount columns. I have to manually delete it every time and run the next macro. I need your expert advice & help to remove the zero with the help of editing the formula.

remove 0 with formula within the formula.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2	A	B	C	D	E	F	G		H		A	B	C	D	E	Amt	F	Amt	G
3									0				0		0	0	0		0
4																0	0		0
5
6
7
8
9
Query

Cell Formulas
Range	Formula
K3:K8	K3	=IFERROR(INDEX($A$3:$I$2000,MATCH($M3,$C$3:$C$2000,0),1),"")
L3:L8	L3	=IFERROR(INDEX($A$3:$I$2000,MATCH($M3,$C$3:$C$2000,0),2),"")
M3	M3	=IFERROR(INDEX($C$3:$C$2000,MATCH(0,COUNTIF($M2:$M$2,($C$3:$C$2000)),0)),"")
M4,M6:M8	M4	=IFERROR(INDEX($C$3:$C$2000,MATCH(0,COUNTIF($M$2:$M3,($C$3:$C$2000)),0)),"")
N3:N8	N3	=IF(IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS(N4:$O4)+1)/2)),4),"")="","")
O3:O8	O3	=IF(M3="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS(O4:$O4)+1)/2)),5),""))
P3:P8	P3	=IF(M2="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS($O3:P3)+1)/2)),9),""))
Q3:Q8	Q3	=IF(M2="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS($O4:Q4)+1)/2)),5),""))
R3:R8	R3	=IF(M2="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS($O3:R3)+1)/2)),9),""))
S3:S8	S3	=IF(M2="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS($O4:S4)+1)/2)),5),""))
I3:I9	I3	=IF(A2="","",SUM(F3:G3))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[RAJESH1960]

I tried adding &"" in the end of the formula. It helped in some columns but not in all the columns. Sharing the file with data to explain you better.

remove 0 with formula within the formula.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1
2	A	B	C	D	E	F	G		H		A	B	C	D	E	Amt	F	Amt	G	Amt
3	01-07-2021	Receipt	1448		ABC	-5000.00			-5000		01-07-2021	Receipt	1448		ABC	-5000	Round Off	1.45	Manoj	4998.55
4	01-07-2021	Receipt	1448		Round Off		1.45		1.45		02-07-2021	Payment	1449		ABC	8250	Rent	-15000	TDS	6750
5	01-07-2021	Receipt	1448		Manoj		4998.55		4998.55		02-07-2021	Payment	1450		ABC	25993	Bank Loan	-12060	Interest Paid	-13933
6	02-07-2021	Payment	1449		ABC		8250.00		8250				0			0
7	02-07-2021	Payment	1449		Rent	-15000.00			-15000							0
8	02-07-2021	Payment	1449		TDS		6750.00		6750
9	02-07-2021	Payment	1450		ABC		25993.00		25993
10	02-07-2021	Payment	1450		Bank Loan	-12060.00			-12060
11	02-07-2021	Payment	1450		Interest Paid	-13933.00			-13933
12									0
Query

Cell Formulas
Range	Formula
K3:K8	K3	=IFERROR(INDEX($A$3:$I$2000,MATCH($M3,$C$3:$C$2000,0),1),"")
L3:L8	L3	=IFERROR(INDEX($A$3:$I$2000,MATCH($M3,$C$3:$C$2000,0),2),"")
M3	M3	=IFERROR(INDEX($C$3:$C$2000,MATCH(0,COUNTIF($M2:$M$2,($C$3:$C$2000)),0)),"")
N3:N8	N3	=IF(IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS(N4:$O4)+1)/2)),4),"")="","")
O3:O8	O3	=IF(M3="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS(O4:$O4)+1)/2)),5),""))&""
P3:P8	P3	=IF(M2="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS($O3:P3)+1)/2)),9),""))&""
Q3:Q8	Q3	=IF(M2="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS($O4:Q4)+1)/2)),5),""))&""
R3:R8	R3	=IF(M2="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS($O3:R3)+1)/2)),9),""))&""
S3:S8	S3	=IF(M2="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS($O4:S4)+1)/2)),5),""))&""
T3:T8	T3	=IF(M2="","",IFERROR(INDEX($A$3:$I$2000,AGGREGATE(15,6,(ROW($C$3:$C$2000)-ROW($C$2))/($C$3:$C$2000=$M3),INT((COLUMNS($O3:T3)+1)/2)),9),""))&""
M4:M8	M4	=IFERROR(INDEX($C$3:$C$2000,MATCH(0,COUNTIF($M$2:$M3,($C$3:$C$2000)),0)),"")
I3:I12	I3	=IF(A2="","",SUM(F3:G3))&""
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[RAJESH1960]

Problem solved. Adding &"" and dragging the formula to the last row, worked.