Transpose At Every Blank Row
|
|
1
|
258
|
December 25, 2020
|
Populating an array
|
|
5
|
245
|
August 8, 2022
|
Determining the dimensions of an array
|
|
3
|
235
|
August 8, 2022
|
Is it possible to somehow pass the results of an array formular to another function with a scalar as a return value?
|
|
3
|
135
|
July 20, 2022
|
How to generate arrays consisting of non-consecutive columns, for use in LINEST (or other array functions)
|
|
3
|
380
|
May 31, 2022
|
Agrupar contas TreeControl
|
|
3
|
445
|
April 23, 2022
|
Performant Array sort (in memory) according to date/time
|
|
19
|
695
|
April 9, 2022
|
Get Used Range of Sheet
|
|
2
|
556
|
April 9, 2022
|
Calc Macro: How to store key value pairs
|
|
13
|
661
|
April 3, 2022
|
Logical array multiplication
|
|
5
|
346
|
December 21, 2021
|
Array function help in Calc macros
|
|
12
|
833
|
December 10, 2021
|
Let a cellvalue define the Arrays (Single-row) in COUNTIF
|
|
3
|
155
|
December 3, 2021
|
Can XPySort work in LibreOffice?
|
|
20
|
556
|
September 29, 2021
|
Basic: How to check if an array contains an item?
|
|
6
|
731
|
August 1, 2021
|
vlookup fails due to trailing spaces
|
|
7
|
319
|
May 12, 2021
|
How to combine two arrays into one
|
|
6
|
404
|
August 1, 2021
|
Why does Array Function get reset to non-Array Function?
|
|
8
|
409
|
May 2, 2021
|
Create Matrix from two tables
|
|
3
|
223
|
February 16, 2021
|
Showing how many times a word appears in a column only when a different word is in a different column
|
|
4
|
264
|
February 12, 2021
|
Match function for other Sheet(s) and/or array?
|
|
1
|
532
|
January 28, 2021
|
"You cant change only part of an array" when sorting rows/columns
|
|
6
|
3637
|
January 15, 2021
|
"How to:" Scan array and produce summary
|
|
3
|
259
|
December 21, 2020
|
Clustering on multiple conditions
|
|
0
|
234
|
December 19, 2020
|
Search array of strings inside other string
|
|
7
|
593
|
November 21, 2020
|
Generating a large number of formatted cells with MACRO (BASIC)
|
|
9
|
269
|
November 13, 2020
|
Unknown user action causes array formula to display syntax (not result)
|
|
8
|
249
|
November 3, 2020
|
Array Formula
|
|
5
|
532
|
October 30, 2020
|
Split concatenated text
|
|
8
|
386
|
August 1, 2021
|
Structure containing array of structure
|
|
3
|
167
|
August 1, 2021
|
Can vlookup return an array? easy way to find one value depending on multiple other entries
|
|
4
|
1459
|
August 22, 2020
|