Hi Govind
Thank you for your reply
Is there an other way with a formula because the next day I have to do this
all over again
thanks

"Govind" wrote:

Hi,

Use Filter-Auto filter and select those rows (usign the condition that
value is zero in first column and error message in second column) and
then delete those rows.

Govind.

bill gras wrote:

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