Keywords: clear search

Welcome to the Futurama Support Site

The Futurama Support Site is the website where you can find Futurama and Futurama Vision documentation. If you have any questions about the support pages or if you want to provide us feedback please send us an e-mail.

Index FindPreviousRow

451 documents found.

FindPreviousRow

Futurama-Editor
Futurama-Formulas
Developer

Module: Editor

Version: 2.2.1 +

Type: Long/Double

Category: Table

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.

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.

Table:

Column 1Column 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.

Related Topics

FindRow: The formula 'FindRow' returns the row number of a reference. This refererence can be a text, a date, a real number or an integer.

FindNextRow: The formula 'FindNextRow' gets the row number of a specified value or the row number of the value that comes next to the specified value.

2014-09-23