OFFSET function height demonstration (WS)


0. Quick guide to the OFFSET height parameter


SYNTAX: OFFSET(reference, rows, cols, [height], [width])


1. Example


This example includes a development worksheet for implementation of the Stock Analyser project. The analyst can select an analysis date (start date) and an associated data window of certain length, that returns a date vector (array) of historical dates, earlier in calendar time than the analysis date. The dates are in ascending order, thus the window extends to rows above the start date.


xlf-offset-height-demonstrator
Fig 1: OFFSET height - negative value height arguments (rows 14 to 16), compared to positive value height arguments (rows 22 to 24 )

2. Additional features


Custom views in the Work area panel that hide a drawing layer image.