What Function
I have a table of cells:
A B C D E
1/1/07 5
1/15/07 6
2/1/07 3
(empty) 2
(empty)
(empty)
(empty)
etc.
What formula do I use to look up the highest value in column A and retrieve
the value from THE NEXT ROW in column E. (I need to retrieve the 2)
|