Search:

Type: Posts; User: myredroom; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Find consecutive cells above a certain value, ignoring zeroes.

    This also hasn't achieved the desired results.:

    <colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
    2





    0
  2. Re: Find consecutive cells above a certain value, ignoring zeroes.

    This gives the following results:


    <tbody>
    3


    2
  3. Re: Find consecutive cells above a certain value, ignoring zeroes.

    Correction, Roger Ward is zero because the preceding week didn't reach target. I fired off my reply a bit quick there!
  4. Re: Find consecutive cells above a certain value, ignoring zeroes.

    oops, sorry my mistake!
  5. Find consecutive cells above a certain value, ignoring zeroes.

    I am trying to count the number of values in preceding cells which are greater than a certain value (in this case 19), but ignoring zero values.

    Put another way, I want to find the number of...
Results 1 to 5 of 5