Reference sheet name from cell value in match formula
|
|
3
|
1840
|
July 31, 2021
|
Get field by matching ID from another sheet
|
|
2
|
909
|
July 31, 2021
|
Returning contents of row below if specific text is found in a columns' list
|
|
3
|
1883
|
July 31, 2021
|
Functionaccess "offset" & "match"
|
|
4
|
1564
|
July 31, 2021
|
The Function Match in libreCalc behaves not like Excel
|
|
3
|
585
|
July 31, 2021
|
Find max cells in a range
|
|
3
|
4156
|
July 31, 2021
|
Cells no longer match text after copy paste
|
|
2
|
534
|
July 31, 2021
|
Why returning Zero value
|
|
8
|
3145
|
July 31, 2021
|
Index match (or) function
|
|
2
|
2643
|
July 31, 2021
|
Index match #n/a error
|
|
3
|
1072
|
July 31, 2021
|
index / match function
|
|
4
|
3909
|
July 31, 2021
|
Find a value i a column and report last value the row with that previously found value
|
|
3
|
929
|
July 31, 2021
|
VLookup searching for cell text in a range? Formula help?
|
|
2
|
2332
|
July 31, 2021
|
Get value and Concattenate
|
|
1
|
377
|
July 31, 2021
|
Can't use function CELL with CONCATENATE to retrieve cell data from another sheet
|
|
5
|
767
|
July 31, 2021
|
Match data and EXTRACT cell ADDRESS
|
|
5
|
4485
|
July 31, 2021
|
question about match function for calc
|
|
1
|
635
|
July 31, 2021
|
Easy way to count search results in Calc
|
|
4
|
3021
|
July 31, 2021
|
Total by contents of a different column
|
|
6
|
560
|
July 31, 2021
|
Get last value of a column where another cell value equals to
|
|
2
|
1225
|
July 31, 2021
|
How to find the previous value in a similar groups?
|
|
4
|
373
|
July 31, 2021
|
Stock value month by month
|
|
4
|
894
|
July 31, 2021
|
How do you match multiple columns in Calc?
|
|
2
|
7331
|
July 31, 2021
|
Calc lookup
|
|
1
|
686
|
July 31, 2021
|
How do I find the first and last matches in a dataset?
|
|
2
|
1778
|
July 31, 2021
|
How to compare numbers in two columns
|
|
6
|
30806
|
July 31, 2021
|
Combinate multiple columns
|
|
1
|
532
|
July 31, 2021
|
How to match common string in a column
|
|
4
|
802
|
July 31, 2021
|
[Calc] Partial word searches, using cell references and regular expressions
|
|
5
|
3763
|
July 31, 2021
|
[^a]* meaning of it in example
|
|
2
|
871
|
July 31, 2021
|