Re: problem with #value!/zero

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
> >
>
.