Thread
:
skipping zeros
View Single Post
#
3
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
skipping zeros
1) =A1*B1*C1 and copy down the column
That will result in all zeros because if any column has a zero then the
result will be zero.
Better to use something like:
=IF(COUNTIF(A2:C2,0)=3,"",1)
The highlight all the data in Column D and select Edit Goto Special
Formulas tick just Text then OK
Next Edit Delete Entire Row OK
Then clear the formulas in Column D
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Joel" wrote in message
...
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 ??
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann