MINIF
Formula Explanation
Filters the data rows based on the given condition and retrieves the minimum value from the specified column.
Formula Syntax
Result column input: minif(column number of the original table to retrieve values from, condition)
Column number of the original table to retrieve values from: The column from which you want to retrieve values, e.g., AA1, AD12.
Condition: Filters the numeric values in the data column, e.g., AB2="phone" and AH3=AI1.
Usage Example
Find the minimum value of DN2 in DM3, with the condition DN2=DM2. Write the result in DN3.
DP3 = minif(DO3,DO2=DP2)