How to get incremental volume reference to the time interval

[mrprofit]

I have this WB to get live data, the volume data of the server is in accumulated volume, as in U4, and i have macro to input the data into column T by time interval, I would like to get the incremental volume in the set time interval (3min interval for this example), in Column H, so the cumulative volume is calculated down to 3min incremental volume. What is the formula for H column?

Many thanks for your help.


Book1.xlsx

cross post
http://www.excelfox.com/forum/f2/how...1968/#post9169

[[email protected]]

Use this formula in column J3...if required do some changes.

=INDEX($T$2:$T$5002,MATCH(C3,$R$2:$R$5002,1),1)-INDEX($T$2:$T$5002,MATCH(C2,$R$2:$R$5002,1),1)

Regards,
Suhas

[mrprofit]

thank you for the help

[mrprofit]

I found a new issue, if the server lagged for a few seconds, the data in T will get some blank no value cells, and the result of J will get "0" (which is fine) or a negative of the cumulative volume (dont want this result). I think if the formula can subtract the Maximum value of the previous cell of cumulative volumes, would return the result, how to modify this to the formula,

Thanks again

[mrprofit]

i change the formula to this, but still will get the cumulative total vol in J ,

=IF(INDEX($T$2:$T$5002,MATCH(C3,$R$2:$R$5002,1),1)-INDEX($T$2:$T$5002,MATCH(C2,$R$2:$R$5002,1),1)<0,0,INDEX($T$2:$T$5002,MATCH(C3,$R$2:$R$5002,1),1)-INDEX($T$2:$T$5002,MATCH(C2,$R$2:$R$5002,1),1))