MAX
Formula Explanation
The MAX
formula is used in conjunction with the FIND
formula to find the maximum value in a set of data objects.
Formula Syntax
Result column input: max(find(target column number, condition, maximum length of the returned array))
Usage Example
Find the maximum value in column DI2 of table DI, with the condition DI2=DH2, and write the result in column DI3.
DI3 = max(find(dh3, dh2=DI2, 2))