FInding Max stress values until an instant strain values

Dear Friends,

I have problems finding max value with respect to an instant strain values.May you help me to write an excel code for this.
I have two column datas (stress-strain). I want to find the max stress values until an instant strain values and being written in 3rd column.
I actually do not have any knowledge about macros.
As you see below; the maximum value until an instant strain was written.Although the third row had a value of 0, max stress was found to be 0.00249 until a strain of 0.01685.
Is there anyone can program this would be great.
Thank you

stress ___ strain __ 3. column (macro calculates)
0 _____ 0 _______ 0
0.00249 0.00562 0.00249
0.00249 0.01124 0.00249
0_____ 0.01685 0.00249
0.00249 0.01685 ....
0.00249 0.02247
0.00498 0.02247
0.00498 0.02809
0.00498 0.03371
0.00746 0.03933
0.00995 0.03933
0.01244 0.04494
0.01244 0.05056
0.01244 0.05056
0.01493 0.05618
0.01493 0.0618
0.01742 0.06742
0.01742 0.07303
0.0199 0.07303
0.02239 0.07865
0.02239 0.08427
0.02488 0.08427
0.02737 0.08989
0.02737 0.09551
0.02986 0.10112
0.02986 0.10112
0.03483 0.10674
0.03483 0.11236

Hi,

It's not clear, at least to me exactly how you want this to work. Would you upload the workbook and manually add the results you expect, along with a note that explains how you've arrived at the results? You can probably do this with standard Excel functions, but we'll be able to tell when we see the workbook.

It is still not clear to me what you want to do. With one exception (row 7), the value in row C = value in row A. In row 7, the value iin row A was zero and the value in row C was equal to the previous value in row A.

I can reproduce your expected results with this simple formula in D4, copied down:

=IF(A4=0,D3,A4)

but, to be honest, I have no idea what I am trying to do. Can you explain exactly wha you need, breaking it down into very simple terms, so that I can understand...

In C4 and copy down,

=MAX(C3,A4)

Maybe, I understand now...

=MAX($A$7:A7) copied down

Hi Perhaps in C5 copied down

Formula:

Please Login or Register  to view this content.

I guess that was it!! Thanks for the Reputation.