J
joe
Hello all, i have a request for you. i have a spreadsheet that is all layed
out with upto 31(days of month) columns and 50+ rows. my problem is this! i
need a formula that will count the number of days starting with today and
looking backwards to prior days that have a value of >=.26 and will give a
result in a column at the end of the string?
example 1:
starting with C6:AG6 the values are as follows
0.13 0 0.21 0.27 0.11 0.31 0.42 0.13
above count would be 0 - 0 1 0 0 1 2 0
example 2 c10:ag10
0.37 0 0.46 0.55 0.3 0.32 0.21 0.19
above count would be 1 - 2 3 4 5 6 0 0
example 3 c26:ag26
0.72 0 0.59 0.23 0.41 0.3 0.35 0.35
above count would be 1 - 2 0 1 2 3 4
example 4 c32:ag32
0.28 0 0.39 0.07 0.28 0.59 0.25 0.29
above count would be 1 - 2 0 1 2 0 1
the dash represents a day where no data is expected thus the count is
continued from the previous day if over the >=.26 benchmark.
thanks for your continued support
out with upto 31(days of month) columns and 50+ rows. my problem is this! i
need a formula that will count the number of days starting with today and
looking backwards to prior days that have a value of >=.26 and will give a
result in a column at the end of the string?
example 1:
starting with C6:AG6 the values are as follows
0.13 0 0.21 0.27 0.11 0.31 0.42 0.13
above count would be 0 - 0 1 0 0 1 2 0
example 2 c10:ag10
0.37 0 0.46 0.55 0.3 0.32 0.21 0.19
above count would be 1 - 2 3 4 5 6 0 0
example 3 c26:ag26
0.72 0 0.59 0.23 0.41 0.3 0.35 0.35
above count would be 1 - 2 0 1 2 3 4
example 4 c32:ag32
0.28 0 0.39 0.07 0.28 0.59 0.25 0.29
above count would be 1 - 2 0 1 2 0 1
the dash represents a day where no data is expected thus the count is
continued from the previous day if over the >=.26 benchmark.
thanks for your continued support