Implementation for the Excel function INDEX
Syntax :
INDEX ( reference, row_num[, column_num [, area_num]])
INDEX ( array, row_num[, column_num])
referencetypically an area reference, possibly a union of areas
arraya literal array value (currently not supported)
row_numselects the row within the array or area reference
column_numselects column within the array or area reference. default is 1
area_numused when reference is a union of areas
class |
Lookup
Implementation of Excel function LOOKUP.
|
class |
Match
Implementation for the MATCH() Excel function.
|
static class |
NumericFunction.TwoArg |
class |
Rank
Returns the rank of a number in a list of numbers.
|
class |
Sumif
Implementation for the Excel function SUMIF
Syntax :
SUMIF ( range, criteria, sum_range )
rangeThe range over which criteria is applied.
class |
Sumx2my2
Implementation of Excel function SUMX2MY2()
Calculates the sum of differences of squares in two arrays of the same size.
|
class |
Sumx2py2
Implementation of Excel function SUMX2PY2()
Calculates the sum of squares in two arrays of the same size.
|
class |
Sumxmy2
Implementation of Excel function SUMXMY2()
Calculates the sum of squares of differences between two arrays of the same size.
|
class |
XYNumericFunction |
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.
|