Right now I have two cells that are drop-down (light green) in which I can choose date intervals. What I would like to be able to grab a set of data under the “Value” column using the date interval then take the average. Say my most recent date is “9/4/2014” and the other date is “9/2/2014”. I want to take the average from the data set “9, 10, and 20”, and return the value in the yellow cell.
All help appreciated! Cheers!