Search

 

Module: Editor

Version: 2.2.1 +

Type: Long/Double

Category: Table

 

Description

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. As result the row number that contains the Lookup_value or the value that comes next to the Lookup_value is returned. The Lookup_value can be a date, a real number or an integer. The formula 'FindNextRow' 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 bigger than the biggest 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 'FindNextRow' works.

Values parameters

Table:

Column 1Column 2
2 6
4 -7
6 8
8 -9
10 10

 

Lookup_value:

5

Result

Result:

2

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.

FindPreviousRow: 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.

Feedback

If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.

2014-09-22