|
Populating an array
|
|
5
|
140
|
August 8, 2022
|
|
Determining the dimensions of an array
|
|
3
|
173
|
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
|
95
|
July 20, 2022
|
|
How to generate arrays consisting of non-consecutive columns, for use in LINEST (or other array functions)
|
|
3
|
330
|
May 31, 2022
|
|
Agrupar contas TreeControl
|
|
3
|
326
|
April 23, 2022
|
|
Performant Array sort (in memory) according to date/time
|
|
19
|
586
|
April 9, 2022
|
|
Get Used Range of Sheet
|
|
2
|
365
|
April 9, 2022
|
|
Calc Macro: How to store key value pairs
|
|
13
|
490
|
April 3, 2022
|
|
Logical array multiplication
|
|
5
|
262
|
December 21, 2021
|
|
Array function help in Calc macros
|
|
12
|
548
|
December 10, 2021
|
|
Let a cellvalue define the Arrays (Single-row) in COUNTIF
|
|
3
|
133
|
December 3, 2021
|
|
Can XPySort work in LibreOffice?
|
|
20
|
455
|
September 29, 2021
|
|
Basic: How to check if an array contains an item?
|
|
6
|
532
|
August 1, 2021
|
|
vlookup fails due to trailing spaces
|
|
7
|
267
|
May 12, 2021
|
|
How to combine two arrays into one
|
|
6
|
305
|
August 1, 2021
|
|
Why does Array Function get reset to non-Array Function?
|
|
8
|
353
|
May 2, 2021
|
|
Create Matrix from two tables
|
|
3
|
188
|
February 16, 2021
|
|
Showing how many times a word appears in a column only when a different word is in a different column
|
|
4
|
206
|
February 12, 2021
|
|
Match function for other Sheet(s) and/or array?
|
|
1
|
446
|
January 28, 2021
|
|
"You cant change only part of an array" when sorting rows/columns
|
|
6
|
2589
|
January 15, 2021
|
|
Transpose At Every Blank Row
|
|
1
|
187
|
December 25, 2020
|
|
"How to:" Scan array and produce summary
|
|
3
|
234
|
December 21, 2020
|
|
Clustering on multiple conditions
|
|
0
|
198
|
December 19, 2020
|
|
Search array of strings inside other string
|
|
7
|
476
|
November 21, 2020
|
|
Generating a large number of formatted cells with MACRO (BASIC)
|
|
9
|
227
|
November 13, 2020
|
|
Unknown user action causes array formula to display syntax (not result)
|
|
8
|
228
|
November 3, 2020
|
|
Array Formula
|
|
5
|
448
|
October 30, 2020
|
|
Split concatenated text
|
|
8
|
310
|
August 1, 2021
|
|
Structure containing array of structure
|
|
3
|
148
|
August 1, 2021
|
|
Can vlookup return an array? easy way to find one value depending on multiple other entries
|
|
4
|
1209
|
August 22, 2020
|
