|
VLOOKUP for Array function?
|
|
11
|
92
|
April 25, 2024
|
|
IRR on range with condition?
|
|
1
|
87
|
March 19, 2024
|
|
Countif and array
|
|
2
|
179
|
January 24, 2024
|
|
Why does Array Function get reset to non-Array Function?
|
|
12
|
789
|
January 12, 2024
|
|
Convert 2D array to delimited string
|
|
13
|
780
|
April 4, 2023
|
|
Transpose At Every Blank Row
|
|
1
|
523
|
December 25, 2020
|
|
Populating an array
|
|
5
|
1063
|
August 8, 2022
|
|
Determining the dimensions of an array
|
|
3
|
886
|
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
|
447
|
July 20, 2022
|
|
How to generate arrays consisting of non-consecutive columns, for use in LINEST (or other array functions)
|
|
3
|
591
|
May 31, 2022
|
|
Agrupar contas TreeControl
|
|
3
|
891
|
April 23, 2022
|
|
Performant Array sort (in memory) according to date/time
|
|
19
|
1415
|
April 9, 2022
|
|
Get Used Range of Sheet
|
|
2
|
1385
|
April 9, 2022
|
|
Calc Macro: How to store key value pairs
|
|
13
|
1366
|
April 3, 2022
|
|
Logical array multiplication
|
|
5
|
680
|
December 21, 2021
|
|
Array function help in Calc macros
|
|
12
|
2058
|
December 10, 2021
|
|
Let a cellvalue define the Arrays (Single-row) in COUNTIF
|
|
3
|
278
|
December 3, 2021
|
|
Can XPySort work in LibreOffice?
|
|
20
|
985
|
September 29, 2021
|
|
Basic: How to check if an array contains an item?
|
|
6
|
1646
|
August 1, 2021
|
|
vlookup fails due to trailing spaces
|
|
7
|
584
|
May 12, 2021
|
|
How to combine two arrays into one
|
|
6
|
946
|
August 1, 2021
|
|
Create Matrix from two tables
|
|
3
|
492
|
February 16, 2021
|
|
Showing how many times a word appears in a column only when a different word is in a different column
|
|
4
|
414
|
February 12, 2021
|
|
Match function for other Sheet(s) and/or array?
|
|
1
|
986
|
January 28, 2021
|
|
"You cant change only part of an array" when sorting rows/columns
|
|
6
|
7314
|
January 15, 2021
|
|
"How to:" Scan array and produce summary
|
|
3
|
414
|
December 21, 2020
|
|
Clustering on multiple conditions
|
|
0
|
398
|
December 19, 2020
|
|
Search array of strings inside other string
|
|
7
|
1297
|
November 21, 2020
|
|
Generating a large number of formatted cells with MACRO (BASIC)
|
|
9
|
499
|
November 13, 2020
|
|
Unknown user action causes array formula to display syntax (not result)
|
|
8
|
374
|
November 3, 2020
|
