B
bgetson
Given a 15 day period, where each row represents a day, I want to find
the maximum value within a row's respective time-period when all
contiguous values are multiplied together.
If sample data looks a little something like this, where column "A"
has a day #, "B" is each value, and "C" is where this prospective
function would go, column C should list the maximum product of all
contiguous values within the last 15 days. For day 2-11, (2*3) is the
greatest value. But by day 17, the value 5 is the largest.
(day) (value) (max)
A B C
1 2 2
2 3 6
3 6
4 6
5 5 6
6 6
7 1 6
8 2 6
9 2 6
10 6
11 6
.......
17 5
I hope this makes sense, and any help would be appreciated.
-bgetson
the maximum value within a row's respective time-period when all
contiguous values are multiplied together.
If sample data looks a little something like this, where column "A"
has a day #, "B" is each value, and "C" is where this prospective
function would go, column C should list the maximum product of all
contiguous values within the last 15 days. For day 2-11, (2*3) is the
greatest value. But by day 17, the value 5 is the largest.
(day) (value) (max)
A B C
1 2 2
2 3 6
3 6
4 6
5 5 6
6 6
7 1 6
8 2 6
9 2 6
10 6
11 6
.......
17 5
I hope this makes sense, and any help would be appreciated.
-bgetson