named-function Questions
2
Solved
I created a formula to sort positive values.
=SORT(FILTER(A2:A, A2:A>0),1,1)
And turnd it to a named function with this formula definition, and named it SORT_POSITIVE
=SORT(FILTER(range, range&...
Nadeau asked 26/9, 2022 at 8:11
3
=SUM(SEQUENCE(10000000))
The formula above is able to sum upto 10 million virtual array elements. We know that 10 million is the limit according to this question and answer. Now, if the same is im...
Mide asked 22/9, 2022 at 13:10
1
© 2022 - 2025 — McMap. All rights reserved.