ExcelBanter - View Single Post

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!