I'd like to change the above code so that the first value in BV:CF holds as addends for all five sums, and still be divided by the values in Z:AJ. So the result would vary because the values in Z:AJ vary, but Z:AJ is the denominator of the same numerator for all five days. As it is now, the rank ranges are being held constant but being applied to varying BV:CF values. How would I change the above code?![]()
Please Login or Register to view this content.
Bookmarks