I have an xls as attached.Now i want to show only those customer which has sales either in net amount1 or in net amount2.I don't want to display customers with null or zero in both the net amounts.If u see the xls i will be seeing only 1,2,3,7.I would appreciate early help.
Customer address net amt1 net amt2
1 xxx 20 30
2 xxx 35
3 xxx 40
4 xxx
5 xxx 0
6 xxx 0
7 xxx 60