This form returns the count of items in the number array that match a specified criterion for each member of a datalist.

It employs four 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 results are listed in the column to the immediate right of the current data list. The column header provides details of the process employed and parameters used.

Remarks

Where the parameters supplied cannot be resolved the error value -1 is returned.

See also

Array Criterion Analysis