Searching Columns

[Guest]

I have a box (cell) at the top of the page in which I want it to search a
column for the latest date. Once it finds the latest date it takes the data
from a cell in the same row as the latest date. Can this be done? If so, how?

Aviator

 

[Dave Peterson]

You can use a formula like:
=MAX(C:C)
to find the biggest date in column C (if column C contains nothing but dates)

To return the value in the column D that matches the biggest date:
=INDEX(D,MATCH(MAX(C:C),C:C,0))

Debra Dalgleish has some nice notes for =index(match()) at:
http://www.contextures.com/xlFunctions02.html

 

[Guest]

This worked great! Thank you.

I have three additional similar questions.
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?

Thank you so much, I have al of these scenerios, and it's driving me crazy.

Thanks,

Aviator.