View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] vincentwady@gmail.com is offline
external usenet poster
 
Posts: 20
Default reference the latest date's data in an array

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