Column Formula (Range Selection)
I have a column of data sequenced in time, most recent result at the top of the table. I want the top row value of a new column to be evaluated (Maximum minus the Minimum) at that most recent time and a fixed # proceeding values (say the previous 14).So each new value at each time will be the peak-to-peak variation of 15 results; the previous 14 results the one at the current time. If was in Exce...