Support Board
Date/Time: Sun, 15 Jun 2025 16:29:15 +0000
Post From: Which one of these formulas is more CPU friendly in Spreadsheet Studies?
| [2025-06-03 17:29:39] |
| C_Money - Posts: 83 |
|
In SC's spreadsheet study, which of these is more CPU efficient: 1) MAX(A3:A40) = 3
2) MOSTRECENTNONZEROVALUE(A3:A40) = 3
Trying to optimize my charts because I use a lot of MOSTRECENTNONZEROVALUE with huge ranges and chart recalculations typically take over 1000ms to complete.
|