In article ,
"Aviator" wrote:

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))

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

=IF(COUNT(C:C),INDEX(D:D,MATCH(MAX(C:C),C:C,0)),"O pen")

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

A3:

For every second row starting with the first cell in the range...

=MAX(IF(MOD(ROW(C3:C589)-CELL("row",C3)+0,2)=0,C3:C589))

....confirmed with CONTROL+SHIFT+ENTER.

For every second row starting with the second cell in the range...

=MAX(IF(MOD(ROW(C3:C589)-CELL("row",C3)+1,2)=0,C3:C589))

....confirmed with CONTROL+SHIFT+ENTER.

A4:

=IF(COUNT(C3:C589),INDEX(D3:D589,MATCH(A3,C3:C589, 0)),"Open")

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

A3:

For every second row starting with the first cell in the range...

=LARGE(IF(MOD(ROW(C3:C589)-CELL("row",C3)+0,2)=0,C3:C589),2)

....confirmed with CONTROL+SHIFT+ENTER.

For every second row starting with the second cell in the range...

=LARGE(IF(MOD(ROW(C3:C589)-CELL("row",C3)+1,2)=0,C3:C589),2)

....confirmed with CONTROL+SHIFT+ENTER.

A4:

=IF(COUNT(C3:C589),INDEX(D3:D589,MATCH(A3,C3:C589, 0)),"Open")

Hope this helps!