Average between 2 values on Excel using VBA

January 18, 2011 at 12:26:16
Specs: Windows Vista

I have an Excel sheet with time values in column A (for example from 0s to 600s) and I would like to calculate the average value in column C of values in column B every 15s (from 0 to 15, 15 to 30...). The thing is that it can happen that I will only have 2 values in B between 0s and 10s (=2 rows) but maybe 15 values between 515s and 530s.
Don't know if I am clear. Is there anyone who can help with that?


See More: Average between 2 values on Excel using VBA

Report •

January 18, 2011 at 15:28:56
re: "Don't know if I am clear."

Not to me.

Read the How To referenced in the next line and then post an example of your data along with the expected result.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question