On sheet 2 I have a start and end date that are variable with another cell that is variable between E and W, and in the result cell I would like the average percentage calculated from sheet 1 for between the 2 dates on either the E or W line.
Hope that makes sense. Example sheet attached. Many Thanks.
Bookmarks