MAXIF
Formula Explanation
Filters the data rows based on the given condition and retrieves the maximum value from the specified column.
Formula Syntax
Result column input: maxif(original table column number to retrieve values from, condition)
- Original table column number to retrieve values from: The column from which values are to be retrieved, e.g., AA1, AD12.
- Condition: Filters the numerical values in the data column, e.g., AB2="Mobile" and AH3=AI1.
Usage Example
Find the maximum value of DK2 in DJ3 and write the result in DK3.
DK3 = maxif(DJ3,DJ2=DK2)