MIN
Formula Explanation
The MIN
formula is used in conjunction with the FIND
formula to find the minimum value among a set of data objects.
Formula Syntax
Result column input: min(find(target column number, condition, maximum length to return array))
Usage Example
Find the minimum value of column DN2 in the DN table among the values in column DM3 of the DM table, with the condition DM2=DN2. Write the result in column DN3.
DN3 = min(find(dm3, dn2=dm2, 5))