skipping zeros
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 ?? |
skipping zeros
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 ?? |
skipping zeros
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 ?? |
All times are GMT +1. The time now is 05:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com