|
How to generate arrays consisting of non-consecutive columns, for use in LINEST (or other array functions)
|
|
3
|
135
|
May 31, 2022
|
|
Agrupar contas TreeControl
|
|
3
|
136
|
April 23, 2022
|
|
Performant Array sort (in memory) according to date/time
|
|
19
|
310
|
April 9, 2022
|
|
Get Used Range of Sheet
|
|
2
|
113
|
April 9, 2022
|
|
Calc Macro: How to store key value pairs
|
|
13
|
202
|
April 3, 2022
|
|
Logical array multiplication
|
|
5
|
197
|
December 21, 2021
|
|
Array function help in Calc macros
|
|
12
|
345
|
December 10, 2021
|
|
Let a cellvalue define the Arrays (Single-row) in COUNTIF
|
|
3
|
95
|
December 3, 2021
|
|
Can XPySort work in LibreOffice?
|
|
20
|
331
|
September 29, 2021
|
|
Basic: How to check if an array contains an item?
|
|
6
|
313
|
August 1, 2021
|
|
vlookup fails due to trailing spaces
|
|
7
|
197
|
May 12, 2021
|
|
How to combine two arrays into one
|
|
6
|
181
|
August 1, 2021
|
|
Why does Array Function get reset to non-Array Function?
|
|
8
|
291
|
May 2, 2021
|
|
Create Matrix from two tables
|
|
3
|
143
|
February 16, 2021
|
|
Showing how many times a word appears in a column only when a different word is in a different column
|
|
4
|
150
|
February 12, 2021
|
|
Match function for other Sheet(s) and/or array?
|
|
1
|
315
|
January 28, 2021
|
|
"You cant change only part of an array" when sorting rows/columns
|
|
6
|
1523
|
January 15, 2021
|
|
Transpose At Every Blank Row
|
|
1
|
138
|
December 25, 2020
|
|
"How to:" Scan array and produce summary
|
|
3
|
170
|
December 21, 2020
|
|
Clustering on multiple conditions
|
|
0
|
153
|
December 19, 2020
|
|
Search array of strings inside other string
|
|
7
|
302
|
November 21, 2020
|
|
Generating a large number of formatted cells with MACRO (BASIC)
|
|
9
|
166
|
November 13, 2020
|
|
Unknown user action causes array formula to display syntax (not result)
|
|
8
|
184
|
November 3, 2020
|
|
Array Formula
|
|
5
|
342
|
October 30, 2020
|
|
Split concatenated text
|
|
8
|
223
|
August 1, 2021
|
|
Structure containing array of structure
|
|
3
|
112
|
August 1, 2021
|
|
Can vlookup return an array? easy way to find one value depending on multiple other entries
|
|
4
|
898
|
August 22, 2020
|
|
Dimensionierung und Deklaration von Array's
|
|
0
|
201
|
August 14, 2020
|
|
Calc: add a new row when using array functions
|
|
5
|
656
|
June 10, 2020
|
|
Teile eines Datensatzes kopieren und in einen anderen speichern
|
|
3
|
336
|
June 5, 2020
|
