|
IRR on range with condition?
|
|
1
|
83
|
March 19, 2024
|
|
Countif and array
|
|
2
|
175
|
January 24, 2024
|
|
Why does Array Function get reset to non-Array Function?
|
|
12
|
777
|
January 12, 2024
|
|
Convert 2D array to delimited string
|
|
13
|
758
|
April 4, 2023
|
|
Transpose At Every Blank Row
|
|
1
|
516
|
December 25, 2020
|
|
Populating an array
|
|
5
|
1027
|
August 8, 2022
|
|
Determining the dimensions of an array
|
|
3
|
858
|
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
|
441
|
July 20, 2022
|
|
How to generate arrays consisting of non-consecutive columns, for use in LINEST (or other array functions)
|
|
3
|
584
|
May 31, 2022
|
|
Agrupar contas TreeControl
|
|
3
|
880
|
April 23, 2022
|
|
Performant Array sort (in memory) according to date/time
|
|
19
|
1378
|
April 9, 2022
|
|
Get Used Range of Sheet
|
|
2
|
1367
|
April 9, 2022
|
|
Calc Macro: How to store key value pairs
|
|
13
|
1345
|
April 3, 2022
|
|
Logical array multiplication
|
|
5
|
670
|
December 21, 2021
|
|
Array function help in Calc macros
|
|
12
|
2020
|
December 10, 2021
|
|
Let a cellvalue define the Arrays (Single-row) in COUNTIF
|
|
3
|
272
|
December 3, 2021
|
|
Can XPySort work in LibreOffice?
|
|
20
|
953
|
September 29, 2021
|
|
Basic: How to check if an array contains an item?
|
|
6
|
1614
|
August 1, 2021
|
|
vlookup fails due to trailing spaces
|
|
7
|
576
|
May 12, 2021
|
|
How to combine two arrays into one
|
|
6
|
925
|
August 1, 2021
|
|
Create Matrix from two tables
|
|
3
|
484
|
February 16, 2021
|
|
Showing how many times a word appears in a column only when a different word is in a different column
|
|
4
|
407
|
February 12, 2021
|
|
Match function for other Sheet(s) and/or array?
|
|
1
|
975
|
January 28, 2021
|
|
"You cant change only part of an array" when sorting rows/columns
|
|
6
|
7252
|
January 15, 2021
|
|
"How to:" Scan array and produce summary
|
|
3
|
401
|
December 21, 2020
|
|
Clustering on multiple conditions
|
|
0
|
390
|
December 19, 2020
|
|
Search array of strings inside other string
|
|
7
|
1247
|
November 21, 2020
|
|
Generating a large number of formatted cells with MACRO (BASIC)
|
|
9
|
478
|
November 13, 2020
|
|
Unknown user action causes array formula to display syntax (not result)
|
|
8
|
373
|
November 3, 2020
|
|
Array Formula
|
|
5
|
918
|
October 30, 2020
|
