This is a continuation of a previous question
. In my attached sheet, I have a series of S and A values representing a TCP conversation. The A-S column shows the difference in values between the last "S" and the current "A" value.
What I need to do is automatically calculate the time difference between a row that has a negative A-S value and the next row that has a none-negative "A-S" value.
So, if we look at D11, we see we have a negative A-S value. The next "A-S" value that is none-negative is that in D13. The difference in TIME between D11 and D13 is shown in E13.
Can someone advise please?