I was just given the formala below. It works great. I need to incorporate
three additional scenarios.

=INDEX(D:D,MATCH(MAX(C:C),C:C,0))

I have three additional scenarios:
1. Can you do the same thing but if there is no values have it left blank or
return Open? (Currently, it shows #NA)

2. Can you do the same thing except just include odd numbered rows? (ie. D3,
D5.... D589)?

3. Can you do the same thing except instead of the biggest date have the
second biggest date?

Thanks,

Aviator.