I need a formula that returns values from min to max, from an array of 3 values. If there are repeats with those 3 values, it must return zero.
i.e. column 1 is always the minimum
column 2 is greater than column 1 or zero
Column 3 is greatest value or zero
there are not always 3 values in the array, in some cases value appear more than once in the array.
Solved by A. Y. in 23 mins