Support Board
Date/Time: Sat, 25 Apr 2026 02:42:35 +0000
Post From: MEDIAN() of range in SC non-CLR spreadsheet
| [2014-05-22 17:29:37] |
| Sawtooth - Posts: 4328 |
|
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. |