Re: problem with #value!/zero

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

.

Relevant Pages

  • Re: Wilcoxon test - too sensitive?
    ... much about looking at Wilcoxon tests.] ... T is still equal to zero! ... The standard deviation ... in random order, separately from the random order of ...
    (sci.stat.edu)
  • RE: Need Help for Round the Value
    ... Make sure that you don't have a zero in your second column. ... Anyway post your error message, sot hat we can discuss further. ... > round it using Math.Roundfunction to precision of 2 ...
    (microsoft.public.dotnet.framework.aspnet)
  • problem with #value!/zero
    ... the zero and value cells are not always in the ... same order they are in random order ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Zero values cause errors on log scale
    ... >>If these zero values are "real" then a log scale is not appropriate, ... > The Excel error message is infuriating because it cannot be disabled on ... > a per plot basis. ... > Martin Brown ...
    (microsoft.public.excel.charting)
  • Re: Customize the effect of enumerate()?
    ... you expecting that will be neither less than zero, greater than zero, ... I don't like the error message. ... tell the caller what went wrong and why it is an invalid index. ... programming that defensively, I'd write: ...
    (comp.lang.python)
Loading