Show the max value of a column according to a given date and show its definition

S

Shadow_Otixz

Given:

For Sheet1:
A1: 11/2/04 (This is the current date)
A4: Project Code
A5: Dent
A6: Stain

B4: 11/3/04
B5: 10
B6: 5

C4: 11/4/04
C5: 12
C6: 20

Question: How can I have the maximum number value of the current dat
displayed in A1?

Desired Solution:
A15: (this cell will display the max value of the column given by th
current date.)
B15: (this cell will display the Reason Code of the max value of th
current date)

Logic: If the date in A1 is changed, the value of A15 and B15 will b
changed as
well regarding to the current date in A
 
Top