Hi everyone,
I have a tricky problem that I need some help on. I have a list of dates and their values. Some values have the same date. I need to determine the AVERAGE value from the last 5 days (not the last 5 entries). Since there are multiple entries, I am having a hard time counting the days to use. See the workbook for clarification.
Thanks for the help
Bookmarks