Maxifs
Description
Minimum Origin Version Required: 2019 SR0
This function returns the maximum value from a given dataset vd that satisfies a specified condition con.
Syntax
double Maxifs(vector vd, string con$)
Parameters
vd
- A dataset or specified column in Origin worksheet from which the maximum value is found.
con
- the condition you use to find a sub-range within vd. It can be an expression and must be inclosed by double quotation ("").
Return
Return the maximum value from a set of values that satisfies a specified condition.
Example
col(A) = data(1,32); maxifs(col(A),"col(A) > 5 && col(A) < 10")=; // Return 9
//simpler condition maxifs(col(A), "<10")=;