This form returns the position in the number array that of the Nth item in the series that matches the criterion for each member of a datalist. The results of this analysis can be used to return the details of the numeric values at those positions.

It employs five parameters or arguments.

These are

• the column of aplhanumeric strings under investigation
  
• the characteristic of the number being analysed - Number Value, Start Position, String Length
  
• the comparison operator being employed (can be either a single operator or a column of operators specific to each alphanumeric string, but this must be specified using the option button)
  
• the value for comparison (can be either a single value or a column of values specific to each alphanumeric string, but this must be specified using the option button)
  
• the Nth value in the series (can be either a single value or a column of values specific to each alphanumeric string, but this must be specified using the option button)

The results below show the positions returned for each Nth value in the series.

Remarks

Where the value of N exceeds the number of items matched, then the error value -1 is returned.

See also

Array Criterion Analysis