I've attached a worksheet which illustrates a desired answer for a formula I don't know how to write.
The challenge for me is this: As an example, say that column b has a range of numbers. elsewhere in the sheet I've set a variable, which in this case is 12.
in column C I want to get the max of a range which begins 12 rows up in column B, but goes down 1/2 the variable of 12.
any advice? thanks.
Bookmarks