- Excel Desktop Client new !
CUT creates a subset LIST from an existing one.
CUT requires either start and end indexes or a filter that accepts values based on a logical expression.
Any LIST referenced in the logical expression in Filter: must be the same length as the one set in List:
|List:||Enter an existing LIST|
|Start:||Index location of first of several sequential values to cut from LIST, Expressions allowed|
|End:||Index location of last value to cut from LIST, Expressions allowed|
|Filter:||Logical expression, if TRUE then value taken from List:|