Explanation
The goal in this example is to return the minimum value that is unique, i.e.
the minimum value that occurs only once in the data.
By default, this is a list of any value that occurs one or more times in the data.
To enable this feature, the argument needs to be set to TRUE or 1.
This is anarray formulaand must be entered with control + shift + enter, except inExcel 365.
This array is delivered directly to theIF function, which uses it like a filter.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
More than one condition can be tested by nesting IF functions.
