# 🏇🏇🏇🏇🏇 Congrats Tina to be the best! Let’s illustrate Excel array formula with a horse racing game as the following table. Data area in column Horse Name (table raw data) is named as horsename (F2:F16) and column Duration is named as duration (H2:H16).

From provided data, analysis result should be delivered as below. Data area in column Horse Name (table result) is named as nameresult (A2:A6). Here, it can be seen that we need to figure out min, max and average duration time of each horse. In order to obtain it, the main idea is to collect 3 duration time values of each horse based on its name, then find min, max and average from those 3 values.

It means function MIN, MAX and AVERAGE would be used with condition(s) as known as IF. Moreover, each name in table result is compare to the list name (F2:F16) in table raw data, so array formula (or it is also called as matrix) should be used here too.

Let’s see MIN with IF in array formula. Function IF is used to compare each row in nameresult to horsename to obtain 3 duration time values. As be seen from above, it will collect from the raw data 3 values whose have values in horsename match to A2 (Rocky). Then function MIN does it original role, which means returning min result of those 3 values.

Remember that A2 is compare to the whole list horsename, which means array formula; hence, in order to apply it, combination of Ctrl + Shift + Enter should be pressed instead of single Enter. That’s why there are { } in the formula.

Similar to MAX and AVERAGE  Now, let’s figure out who has the best duration (minimum value) for each category.

Here, INDEX and MATCH are used together to find out the best result in MIN category (B2:B6). Then simply drag the formula to column C and D for MAX and AVERAGE category. It can be seen that Tina is the champion in 3 categories. Congrats Tina again!