Hi,

I want to fined the max value from A2, A4, A6, A9 and display it in C1, and fined the corresponding time in B and display it in D1. As you can see A is not ordered, what function I can use for D? Since I can use =Max(a2,a4,a6,a9) for C1.

Thank you