spill-blocked-by-occupied-cell-column |
feature:spill-blocking |
=SEQUENCE(3) |
interaction |
2 |
spill-blocked-by-occupied-cell-row |
feature:spill-blocking |
=SEQUENCE(1, 3) |
interaction |
|
spill-blocked-by-occupied-cell-2d |
feature:spill-blocking |
=SEQUENCE(2, 2) |
interaction |
|
spill-blocked-distant-cell |
feature:spill-blocking |
=SEQUENCE(10) |
interaction |
2 |
no-block-when-result-fits |
feature:spill-blocking |
=SEQUENCE(2) |
value |
|
sort-of-sequence-descending |
SORT |
=SORT(SEQUENCE(5), 1, -1) |
value |
|
sort-of-sequence-ascending |
SORT |
=SORT(SEQUENCE(5), 1, 1) |
value |
|
filter-of-sequence |
FILTER |
=FILTER(SEQUENCE(5), SEQUENCE(5)>2) |
value |
|
unique-of-repeated-column |
UNIQUE |
=UNIQUE({1;2;1;3;2;3}) |
value |
|
sort-of-filter |
SORT |
=SORT(FILTER({5;3;1;4;2}, {TRUE;TRUE;FALSE;TRUE;FALSE})) |
value |
|
index-into-sequence |
INDEX |
=INDEX(SEQUENCE(5, 5), 3, 4) |
value |
|
filter-returns-no-rows |
FILTER |
=FILTER({1;2;3}, {FALSE;FALSE;FALSE}) |
value |
2 |
unique-on-single-value |
UNIQUE |
=UNIQUE({5;5;5}) |
value |
|
transpose-of-sequence |
TRANSPOSE |
=TRANSPOSE(SEQUENCE(3)) |
value |
|
sort-descending-unique |
SORT |
=SORT(UNIQUE({3;1;4;1;5;9;2;6;5;3}), 1, -1) |
value |
|
tocol-of-2d-sequence |
TOCOL |
=TOCOL(SEQUENCE(2,3)) |
value |
|
hstack-two-sequences |
HSTACK |
=HSTACK(SEQUENCE(3), SEQUENCE(3, 1, 10)) |
value |
|
vstack-two-sequences |
VSTACK |
=VSTACK(SEQUENCE(1, 3), SEQUENCE(1, 3, 10)) |
value |
|
sequence-plus-scalar |
op:+ |
=SEQUENCE(3)+10 |
value |
|
two-sequences-multiplied-elementwise |
op:* |
=SEQUENCE(3)*SEQUENCE(3) |
value |
|
row-sequence-times-column-sequence-outer |
op:* |
=SEQUENCE(1,3)*SEQUENCE(3,1) |
value |
|