Support Board

Date/Time: Sat, 17 Jan 2026 14:22:57 +0000

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

[2014-05-22 17:29:37] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4308
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.