If you have many rows, first sort the data by the numeric field. This will
gather all the zeros together and the rows can be deleted with one operation
rather than hunting for them.
--
Gary's Student
"Khers" wrote:
I have a work sheet that has many rows like this and 3 coloums
1 chair custom 24
2 table custom 0
3 spoon custom 3563
4 hat custom 0
now I would like to make another colom and only extract those that
their sum is greather than zero. in other words I would like to delete
rows 2 and 4
how can i do that using if-function or any other function
tnx
khers
|