I am wondering if anyone has any thoughts on how to do this? I am trying to show an average of all the data in range B72:B500, for the time period specified in the range A23:A68 and shown in range F72:F500, for the day specified in row 20 and shown in range A72:A500.
So basically i'm trying to say for this 30 minute time period, on this day, the average "Tick Move Direction" was "X".
If anyone has any thoughts I where to start I would so so appreciate it.
Screen Shot 2016-11-04 at 2.02.40 PM.png
Screen Shot 2016-11-04 at 1.55.52 PM.png
Bookmarks