problem with #value!/zero
how can I delete cells that have a formula and that formula equals 0 (zero)
in one column and #value! in a other column?
eg:- a b
1 0 #value!
2 234.3 3.78
3 0 #value!
4 327 4.712
5 54 23
6 0 #value!
7 0 #value!
8 156 89.7
and so on down to 300 rows . the zero and value cells are not always in the
same order they are in random order
can some one please help?
thanks bill
|