Hi All,
I have a dynamic list of dollar amounts where each day, a new amount gets added to the list.
I would like to get a formula that extracts the highest dollar amount each 5 day period beginning from day 1, then average those high's together, and excluding any 5 day period that does not have a full 5 days yet.
The result I am trying to automate based on the attached spreadsheet is:
The high from Days 1-5=$1875
The High from days 6-10=$2030
Average = $1,952.50
The High from days 11-15 would get averaged in for the total of all 3 five-day periods once those values are added to the chart.
Thanks in advance for the help-
Bookmarks