I am tracking census information in horizontal dynamic ranges on an Input! sheet. The information is being compared among two organizations. Changing the layout is not prudent in this case.
The date is in row Input!3:3 and the values are in row Input!5:5 for organization 1 and Input!32:32 for organization 2. A separate Dashboard! sheet compares sums on a daily, weekly, bi-weekly and 4-week basis. I would like the previous 4-weeks to display sparklines in column Dashboard!U beginning in row 6, based on an manually entered date located in Dashboard!$C:$3.
I'm nearly certain this requires some combination of OFFSET, COUNTA and MATCH functions in named ranges.
The date is in row Input!3:3 and the values are in row Input!5:5 for organization 1 and Input!32:32 for organization 2. A separate Dashboard! sheet compares sums on a daily, weekly, bi-weekly and 4-week basis. I would like the previous 4-weeks to display sparklines in column Dashboard!U beginning in row 6, based on an manually entered date located in Dashboard!$C:$3.
I'm nearly certain this requires some combination of OFFSET, COUNTA and MATCH functions in named ranges.