Array formulas

Operate on whole ranges at once, per formula with ARRAYFORMULA or everywhere through array arithmetic mode.

3 stepsWatch it once, then it is yours: click into the grid at any point to take over.

Change the threshold in D1 or any amount: the matches fill the FILTERs’ results, shaded, from the top.

Engine

1hf.getCellFormula({ sheet: 0, col: 2, row: 2 });
2// '=FILTER(A2:A9, B2:B9>D1)'
3
4// D4 holds no formula, and shows its part of the result:
5hf.isCellPartOfArray({ sheet: 0, col: 3, row: 3 });
6// true
7hf.getCellValue({ sheet: 0, col: 3, row: 3 });
8// 610

Edit a cell, and the engine’s answer is timed here.

Make every data point count. Turn millions of them into actionable wisdom.

Let’s make it easier.
Smoother. Faster. All Handsontable.