Multiplying Contiguous Values in an Array
 

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

Multiplying Contiguous Values in an Array
 

skrev i en meddelelse
ups.com...
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


-bgetson

It's not entirely clear to me, what you're trying to accomplish.
Perhaps this can be of help:

1. In C1 enter the formula =B1
2. In C2 the formula =MAX(B2*B1,C1)
3. Copy C2 down with the fill handle (the little square in the
lower right corner of the cell)


--
Best regards
Leo Heuser

Followup to newsgroup only please.