I like you idea , but the formula would make it zero if any of the three are
zero. I would check if each are zero =if(and(a1=0,b1=0,c1=0),0,1) and copy
that down

"Joel" wrote:

The simplies way is to use an auxilary column. In column D put the formula

1) =A1*B1*C1 and copy down the column
2) Add filter to Column D. click on the D at top of column to highlight
entire column. Then Menu Data - Filter - AutoFilter
3) In D1 select in the Filter 0
4) Highlight Rows with data then right click and select delete Row.
5) Remove Filter from Column D by Highlighting column D and going to Data -
Filter - Show All.


"pierre" wrote:

hello i have the following data:

A B C
1 0 -1000 -1000
2 0 0 0
3 100 0 100
4 0 0 0
5 0 0 0
6 0 0 0
7 200 0 200
8 300 0 300

i would like to skip the zeros and make the following :

0 -1000 -1000
100 0 100
200 0 200
300 0 300

IS THERE ANY FORMULA FOR THAT ??