Functionaccess "offset" & "match"
|
|
4
|
1047
|
July 31, 2021
|
The Function Match in libreCalc behaves not like Excel
|
|
3
|
310
|
July 31, 2021
|
Find max cells in a range
|
|
3
|
3244
|
July 31, 2021
|
Cells no longer match text after copy paste
|
|
2
|
332
|
July 31, 2021
|
Why returning Zero value
|
|
8
|
2432
|
July 31, 2021
|
Index match (or) function
|
|
2
|
2198
|
July 31, 2021
|
Index match #n/a error
|
|
3
|
840
|
July 31, 2021
|
index / match function
|
|
4
|
3351
|
July 31, 2021
|
Find a value i a column and report last value the row with that previously found value
|
|
3
|
522
|
July 31, 2021
|
VLookup searching for cell text in a range? Formula help?
|
|
2
|
2071
|
July 31, 2021
|
Get value and Concattenate
|
|
1
|
243
|
July 31, 2021
|
Can't use function CELL with CONCATENATE to retrieve cell data from another sheet
|
|
5
|
504
|
July 31, 2021
|
Match data and EXTRACT cell ADDRESS
|
|
5
|
3717
|
July 31, 2021
|
question about match function for calc
|
|
1
|
519
|
July 31, 2021
|
Easy way to count search results in Calc
|
|
4
|
2387
|
July 31, 2021
|
Total by contents of a different column
|
|
6
|
300
|
July 31, 2021
|
Get last value of a column where another cell value equals to
|
|
2
|
1101
|
July 31, 2021
|
How to find the previous value in a similar groups?
|
|
4
|
282
|
July 31, 2021
|
Stock value month by month
|
|
4
|
638
|
July 31, 2021
|
How do you match multiple columns in Calc?
|
|
2
|
6347
|
July 31, 2021
|
Calc lookup
|
|
1
|
576
|
July 31, 2021
|
How do I find the first and last matches in a dataset?
|
|
2
|
1424
|
July 31, 2021
|
How to compare numbers in two columns
|
|
6
|
30039
|
July 31, 2021
|
Combinate multiple columns
|
|
1
|
364
|
July 31, 2021
|
How to match common string in a column
|
|
4
|
688
|
July 31, 2021
|
[Calc] Partial word searches, using cell references and regular expressions
|
|
5
|
3217
|
July 31, 2021
|
[^a]* meaning of it in example
|
|
2
|
698
|
July 31, 2021
|
How to find a non-sequence match between rows?
|
|
1
|
294
|
July 31, 2021
|
How can I find if an entry in column A exists in column B?
|
|
4
|
73150
|
July 31, 2021
|
Highlight selected word matches
|
|
2
|
2019
|
July 31, 2021
|