reference the latest date's data in an array

[vincentwady]

Dear all,

I face an issue, I have to pull the latest date data in my excel tab.
It looks like below:

A B C D
E F G
6/30/07 7/1/07 7/3/07 7/5/07 7/15/07
7/20/07 Latest Data I need
Security 1 $60 $30
$45 $45
Security 2
$98 $98
|
|
Security 50
$77 $37 $37

Does anyone know what kind of formula I need, can allow me to pull the
latest date from Column(A:F) to Column G. Because the data in Column A
to F is not consitent, I think Vlookup or Index function can't
efficiently work. Or I have to manually maintain this. But hopefully
someone with experience can have a solution, allow me to pull the
information I need.

Thanks

Vincent

 

[Toppers]

=MAX(A1:F1)

???

 

[Toppers]

... to get the data ..

=INDEX($A$1:$F$100,ROW(),MATCH(MAX($A$1:$F$1),$A$1:$F$1,0))

and copy down

HTH