Remove the value if condition meet

[Vishaal]

Hi,

Thanks in advance,

Need help to remove the value in coloumn in following sheet if only "0" coming

Coloumn A
8
6
0
0
2
7
0
0
0

Formula or VBA will delete all the "0" after 7
I have also coloumn B, C, D and E

 

[aqeelnokia99]

=if(and(a2=0,a3=0,a4=0),"",a2)

 

[aqeelnokia99]

1 more
=IF(SUMPRODUCT(A2:$A$17)=0,"",A2)

 

[aqeelnokia99]

u can also use this its batter for u
=IF(SUM(A2:$A$17)=0,"",A2)

 

[Vishaal]

1 more
=IF(SUMPRODUCT(A2:$A$17)=0,"",A2)

Its working fine for me

Thanks for the help Sir Ji

 

[Vishaal]

May i do it through loop or vba

because i have many columns (column A to Column DA)

 

[aqeelnokia99]

u just simply put this formula in DB and drage them until HB colom its total 105 colom as u have copy them down to end
=IF(SUMPRODUCT(A2:A$17)=0,"",A2)

 

[Vishaal]

Thanks aqeelnokia99 ji

Its working for me