Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Tue, 07 May 2024 20:21:42 +0000

How to Post a Message for Support

Post From: MEDIAN() of range in SC non-CLR spreadsheet

[2014-05-22 17:29:37]
[Go To First Post]
Sawtooth - Posts: 3993
In the CLR spreadsheets, I use the INDIRECT function to get all rows, relative to the Number of Rows setting:

=MEDIAN(A3:INDIRECT("A"&$J$30+2))

But apparently INDIRECT is not a supported function in the non-CLR spreadsheets.

IMO, the new spreadsheets are still a long way from being a viable alternative.