running maximum (newbie question)
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. |
running maximum (newbie question)
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 wrote in message ups.com... 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. |
running maximum (newbie question)
wrote in message
ups.com... 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. 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 |
running maximum (newbie question)
David Biddulph wrote: wrote in message ups.com... 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. 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 Thank you so much. |
running maximum (newbie question)
Don Guillett wrote: 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 wrote in message ups.com... 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. 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. |
running maximum (newbie question)
|
running maximum (newbie question)
wrote:
wrote: wrote: 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. [....] 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. I beg your pardon. The other poster's response is indeed exactly what you asked for in your second explanation quoted above. My mistake! |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com