auto calculating formula or macro, not sure.

Originally Posted by ben_hensel

How are you picking the sample ranges? Do you want the first 15 minutes, the last 15 minutes, or the 15 minutes in the middle?

I understand.

This is where the theoretical value comes into play. I am looking for consecutive 15 minutes average closest to the theoretical value. It can be any 15 consecutive minute average. Usually its the average closest to the end.

Since the solution I posted earlier today is based on the 15 minute period with the lowest standard deviation, it should give you exactly what you want.

Lewis