|
How to use MATCH on a variable search range
|
|
3
|
5833
|
December 6, 2019
|
|
How to find where in the interval a number is - For a particular category
|
|
2
|
927
|
July 31, 2021
|
|
Lookup() vs. Index() of Match()
|
|
3
|
34438
|
October 31, 2019
|
|
how to match a cell when the search region is in a different document
|
|
4
|
886
|
October 9, 2019
|
|
Remove duplicates within a row
|
|
7
|
2077
|
July 31, 2021
|
|
Error al leer los datos desde Internet
|
|
3
|
1255
|
August 26, 2019
|
|
cCalc How do I match name and count all cells with corresponding name
|
|
2
|
1465
|
August 13, 2019
|
|
Getting #N/A with INDEX and MATCH
|
|
3
|
1601
|
August 12, 2019
|
|
Pull data from long-form schedule to single day sheet
|
|
5
|
623
|
August 4, 2019
|
|
"match" (in CALC Version: 6.2.2.2 (x64)) is not working right...
|
|
2
|
557
|
July 31, 2021
|
|
How build 4th "target" col based on earlier values compared to 3 cols?
|
|
5
|
745
|
July 25, 2019
|
|
How to use MATCH and INDEX with multiple columns
|
|
3
|
10471
|
June 17, 2019
|
|
Multiple column match, and seek multiple output values from one column
|
|
16
|
4059
|
June 6, 2019
|
|
Hello! On calc, how do I count the cells of range "X" that contain the exact data with cells in range "Y"?
|
|
8
|
4546
|
July 31, 2021
|
|
Aligning two lists in Calc problem fixed by Gilberto
|
|
4
|
574
|
May 11, 2019
|
|
Problem with =Match in Libre Calc
|
|
2
|
977
|
April 20, 2019
|
|
Index Aggregate formula. Need expert help.
|
|
0
|
1003
|
March 19, 2019
|
|
Calc: Match closest text and align extended results
|
|
0
|
460
|
February 5, 2019
|
|
LibreOffice Calc - Partial Match Column Compare Question
|
|
5
|
2026
|
January 5, 2019
|
|
Writer Images/tables match page width?
|
|
2
|
607
|
July 31, 2021
|
|
find value in matrix (in other words: find value based on 2 criteria)
|
|
2
|
1013
|
October 8, 2018
|
|
Match Cells conditional format background.
|
|
4
|
708
|
September 26, 2018
|
|
Loops and Matching: Combine cells from multiple sheets into one.
|
|
0
|
451
|
August 29, 2018
|
|
I'm using the 'match ' command, column of numbers goes from negative to positive, match fails across the transition.
|
|
8
|
461
|
August 13, 2018
|
|
Return a value in a row, based on two other rows
|
|
4
|
1651
|
July 31, 2021
|
|
Match cannot find number in formula cell but okay in value cell
|
|
5
|
1008
|
July 31, 2021
|
|
Formula to return all corresponding values from an array
|
|
3
|
3109
|
July 31, 2021
|
|
I am trying to match the last non blank cell in a row with the header above it. I used this formula in Excel, =LOOKUP(2,1/(L2:R2<>""),M$1:S$1) but its not working in LibreOffice. Any suggestions?
|
|
10
|
5575
|
July 31, 2021
|
|
Libreoffice 6 calc: speed up vlookup, match, index search
|
|
2
|
2258
|
July 31, 2021
|
|
=MATCH confuses "AV." with "AVV"
|
|
3
|
859
|
July 31, 2021
|
