software

Will someone please help with the following question:

I have a column of say 200 values.

In row J I want the highest value that has occurred in rows 1, 2,3...
up to J.

I assume the answer for the minimum value would be similar.

Thanks.Please clarify your question.
J is NOT a row.
What range do you want.
Look at the MAX function and the MIN function in HELP--
Don Guillett
SalesAid Software

gt; wrote in message ups.com...
gt; Will someone please help with the following question:
gt;
gt; I have a column of say 200 values.
gt;
gt; In row J I want the highest value that has occurred in rows 1, 2,3...
gt; up to J.
gt;
gt; I assume the answer for the minimum value would be similar.
gt;
gt; Thanks.
gt;
gt; wrote in message ups.com...
gt; Will someone please help with the following question:
gt;
gt; I have a column of say 200 values.
gt;
gt; In row J I want the highest value that has occurred in rows 1, 2,3...
gt; up to J.
gt;
gt; I assume the answer for the minimum value would be similar.

In row 1, you need the formula =MAX(A$1:A1) [assuming that your data values
are in column A], and copy this down in rows 2 to 200.
As you say, MIN() would work similarly.
--
David Biddulph

David Biddulph wrote:
gt; gt; wrote in message
gt; ups.com...
gt; gt; Will someone please help with the following question:
gt; gt;
gt; gt; I have a column of say 200 values.
gt; gt;
gt; gt; In row J I want the highest value that has occurred in rows 1, 2,3...
gt; gt; up to J.
gt; gt;
gt; gt; I assume the answer for the minimum value would be similar.
gt;
gt; In row 1, you need the formula =MAX(A$1:A1) [assuming that your data values
gt; are in column A], and copy this down in rows 2 to 200.
gt; As you say, MIN() would work similarly.
gt; --
gt; David Biddulph

Thank you so much.
Don Guillett wrote:
gt; Please clarify your question.
gt; J is NOT a row.
gt; What range do you want.
gt; Look at the MAX function and the MIN function in HELP
gt;
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; gt; wrote in message
gt; ups.com...
gt; gt; Will someone please help with the following question:
gt; gt;
gt; gt; I have a column of say 200 values.
gt; gt;
gt; gt; In row J I want the highest value that has occurred in rows 1, 2,3...
gt; gt; up to J.
gt; gt;
gt; gt; I assume the answer for the minimum value would be similar.
gt; gt;
gt; gt; Thanks.
gt; gt;

I got the help I needed. To be more precise I have items
A(1),A(2),...A(200)

I want to set up column B in which

B(J) = MAX((A(1),A(2),...A(J)) for J=1,2,....200.

Since I have the basic answer, I think with some experimentation I can
figure out how to restrict the range to fewer entries (J,J-1,...J-k 1))
instead of going all the way back to cell 1.

wrote:
gt; I got the help I needed. To be more precise I have items
gt; A(1),A(2),...A(200)[.] I want to set up column B in which
gt; B(J) = MAX((A(1),A(2),...A(J)) for J=1,2,....200.
gt; Since I have the basic answer, I think with some experimentation
gt; I can figure out how to restrict the range to fewer entries (J,J-1,...J-k 1))
gt; instead of going all the way back to cell 1.

I do not see any answer remotely resembling what I think you
want. As I understand you now, you want the maximum of a
range, where the at least the beginning and ending row numbers
are variable. I think the following best fits your needs ....

If column A contains the list of values, and B1 and B2 contain
the beginning and ending row numbers, then:

=MAX(OFFSET($A$1,B1-1,0):OFFSET($A$1,B2-1,0))

produces the maximum value in cells A(B1) through A(B2),
written loosely as you did above.

The same paradigm would also permit you so select a variable
column range as well. Also, OFFSET() can be self-referencial.
For example, if the MAX() formula is in C1, the following gives
the same result:

=MAX(OFFSET(C1,B1-1,-2):OFFSET(C1,B2-1,-2))

HTH.wrote:
gt; wrote:
gt; gt; I got the help I needed. To be more precise I have items
gt; gt; A(1),A(2),...A(200)[.] I want to set up column B in which
gt; gt; B(J) = MAX((A(1),A(2),...A(J)) for J=1,2,....200.
gt; gt; Since I have the basic answer, I think with some experimentation
gt; gt; I can figure out how to restrict the range to fewer entries (J,J-1,...J-k 1))
gt; gt; instead of going all the way back to cell 1.
gt;
gt; I do not see any answer remotely resembling what I think you
gt; want. As I understand you now, you want the maximum of a
gt; range, where the at least the beginning and ending row numbers
gt; are variable. I think the following best fits your needs ....
gt;
gt; If column A contains the list of values, and B1 and B2 contain
gt; the beginning and ending row numbers, then:
gt;
gt; =MAX(OFFSET($A$1,B1-1,0):OFFSET($A$1,B2-1,0))
gt;
gt; produces the maximum value in cells A(B1) through A(B2),
gt; written loosely as you did above.
gt;
gt; The same paradigm would also permit you so select a variable
gt; column range as well. Also, OFFSET() can be self-referencial.
gt; For example, if the MAX() formula is in C1, the following gives
gt; the same result:
gt;
gt; =MAX(OFFSET(C1,B1-1,-2):OFFSET(C1,B2-1,-2))
gt;
gt; HTH.

I saved your post. Thanks - I'll try it out later - for now I'm just
using the max running all the way back to cell 1 using the method
pointed out by another poster.

wrote:
gt; wrote:
gt; gt; wrote:
gt; gt; gt; I got the help I needed. To be more precise I have items
gt; gt; gt; A(1),A(2),...A(200)[.] I want to set up column B in which
gt; gt; gt; B(J) = MAX((A(1),A(2),...A(J)) for J=1,2,....200.
gt; [....]
gt; I saved your post. Thanks - I'll try it out later - for now I'm just
gt; using the max running all the way back to cell 1 using the method
gt; pointed out by another poster.

I beg your pardon. The other poster's response is indeed exactly
what you asked for in your second explanation quoted above. My
mistake!