Support Board
Date/Time: Tue, 26 Nov 2024 17:35:03 +0000
Post From: MEDIAN() of range in SC non-CLR spreadsheet
| [2014-05-22 17:29:37] |
| Sawtooth - Posts: 4120 |
|
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. |