In our example MIN(Range) returns the value 0 since 0 is the minimum value in the range of values {1;0;8;6;9;7;9;6}. MATCH(0,Range,0) looks for a 0 in the Range and will return the position of the first 0 it finds. The 0 at the end of the formula is a predefined Excel parameter that tells the MATCH function to find an exact match in the Range. In our example MATCH(0,{1;0;8;6;9;7;9;6},0) returns the value 2 since the first 0 in {1;0;8;6;9;7;9;6} is in the 2nd position.
