303uru
searching Neon…
- 1.▲
- 2.▲
- 3.▲
- 4.▲
- 5.▲
- 6.▲
5 ms·
- 1.▲
- 2.▲
- 3.▲
- 4.▲
- 5.▲
- 6.▲
- 7.▲
- 8.▲
- 9.▲
- 10.▲
- 11.▲
- 12.▲
Oh yes indeed. For example, here's something I was just working on: =LET( h, ROWS(A2#),
names, A2#,
vals, K2:INDEX(K:K, h+1),
denoms, J2:INDEX(J:J, h+1),
k, 20,
groupAvg, SUMPRODUCT(vals, denoms) / SUM(denoms), - 13.▲
- 14.▲
- 15.▲
- 16.▲
- 17.▲
- 18.▲
- 19.▲
- 20.▲
- 21.▲
- 22.▲
- 23.▲
- 24.▲
- 25.▲
- 26.▲
- 27.▲
- 28.▲
- 29.▲
- 30.▲
More ›