I have the following data file where column B shows the data, column C shows the max of the data since inception and column D shows the percentage difference between columns C and D. In cell E1, the minimum of column D is calculated. All straightforward stuff.
I would like to have an array formula that calculates the minimum difference over a set number of days (i.e. last 100 or 200 rows) and does away with columns C and D. So the formula would include lastrow (offset) - the number of rows.(variable).
I have included an example with spreadsheets.