Problem, Year 1 = March - Dec , Year 2 = Jan - July,
so to compare the two I want the previous year total = March - July for current and previous year ;
Then for the current year I used first and last non blankPlease Login or Register to view this content.
This does seem to work but am I overlooking a function or method that might work better, or if this can give incorrect answers,Please Login or Register to view this content.
I have attached the file with working out.
The main problem was to total level, getting the values at the month I could just use First nonblank.
Richard.
Bookmarks