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

How To Find The Position Of The Maximum - 78