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
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: problem with #value!/zero ... 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. ... the zero and value cells are not always in the same order they are in random order... (microsoft.public.excel.worksheet.functions)
countif ... I have a summarizing section of a worksheet in which I need to get an average ... I need to put a condition on it that the average is based on only the cells... This only says if N13 is greater than zero, but I have all the other cells ...Prev by Date: ... (microsoft.public.excel.worksheet.functions)
Re: Random Number Cell Filling ... Big Rick... Please keep all correspondence within the Group, ... What you're looking for is a random order without replacement (no ... The formula also gives gives me random REF# errors in some of the cells.... (microsoft.public.excel.misc)
Re: VlookUp that does not return #N/A ... Im having exactly the same problem with my vlookups...zero for cells which did have figures in ...Prev by Date: ... (microsoft.public.excel.worksheet.functions)
