3 ms·
incompatible though with dynamic "spill" arrays.. maybe 'named ranges' solves the problem? but neither those nor lambdas are available on excel web atm iirc
by smegsicle 5y ago
incompatible though with dynamic "spill" arrays..
maybe 'named ranges' solves the problem? but neither those nor lambdas are available on excel web atm iirc
- listenallyall 5y agoOf course Excel tables are incompatible with dynamic arrays. Does PostgreSQL or SQLite or any RDBMS allow you to have columns with arbitrary and varying sizes in the same table? It doesn't make sense. Web Excel is not Excel, not even going to go there.