Cells D4:I8 as listed.
<tbody>
X
X
Text1
Text2
Text3
Text4
Text5
Lowest
1.12
2.23
2.21
1.22
3.21
1.22
1.29
2.12
1.89
0.00
2.01
2.01
1.17
0.00
2.17
2.88
2.90
1.34
</tbody>
Cells D4:H4 are a named range of EX_C
Cells I6 contains the following formula...