I am looking for a formula when given a daily results will average the results grouping into Julian Week. (Basically 5 days of data averaged, but by week). The formula also needs to excude when values of "0" are reported.
Where:
Column A = Date
Column B = Julian Week Number
Column C= Daily Percentage
Column D= To equal average of daily results within a Julian Week that excludes "0" values.
Bookmarks