Module: Editor
Version: 2.2.1 + and update 20.01 +
Description
The formula 'FindPreviousRow' gets the row number of a specified value or the row number of the value that is previous to the specified value. As result the row number that contains the Lookup_value or a value previous to the Lookup_value is returned. The Lookup_value can be a date, a real number or an integer. The formula 'FindPreviousRow' searches into the first column of a table to find the Lookup_value. Note, the function starts counting the rows with the number 0, so the first row is 0 second row is 1 etc. If the reference is smaller than the smallest value in the table, the result will be -1. For this formula the values in the first column need to be ordered from small to big.
Note: the behavior of the FindPreviousRow formula has changed in Futurama version 20.01 in the situation that there are duplicates of the value to be found in the column. Suppose you have a column with respective values 57,65,67,67, 67, 70. In Futurama 19.12 and earlier the FindPreviousRow formula returns row 4 when looking for nummer 67. From Futurama 20.01 this is the correct value 2. In order to maintain the old behavior the compatibility mode 19_12 is introduced. From Futurama 20.01 + with the compatibility mode 19_12 the formula in the example before still returns row 4.
Parameters
Table:
In this parameter you refer or fill in the table.
Lookup_value:
In this parameter you will fill in your lookup value
Example
Description
In this example you can see how the formula 'FindPreviousRow' works.
Values parameters
Table:
Column 1 |
Column 2 |
2 |
6 |
4 |
-7 |
6 |
8 |
8 |
-9 |
10 |
10 |
Lookup_value:
5
Result
Result:
1
The result is row 2, because 6 comes next to the Lookup_value 5. So the formula returns the row with value 6.