Column Formula (Range Selection)

Fazio9 — Sat, 10 Jun 2023 23:37:26 GMT

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 Excel I could drag the mouse to select a range of cells to evaluate the difference of Min&Max over the range...

Re: Column Formula (Range Selection)

txnelson — Thu, 23 Sep 2021 02:20:13 GMT

If I am correctly interpreting your question, here is one possible way to handle it as a formula for a new column

If( Row() <= 14,
	bottom = 1,
	bottom = Row() - 14
);
Max( :weight[Index( bottom, Row() )] ) - Min( :weight[Index( bottom, Row() )] );

topic Re: Column Formula (Range Selection) in Discussions

Column Formula (Range Selection)

Re: Column Formula (Range Selection)