reference the latest date's data in an array

V

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top