<div>
<div class="content wysiwyg-content">
I got two tabs in excel: 
TAB1 - contains unique record numbers 
TAB2 - contains record data.. records are not in order. 
 
In Tab1 I need a formula to show the record number's name and section with the latest date/time. 
 
 
TAB1 
record# &nbsp; name &nbsp; section 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; john &nbsp; &nbsp; &nbsp; &nbsp; 2 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; russ &nbsp; &nbsp; &nbsp; &nbsp; 1 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ed &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6 
4 
5 
 
TAB2 
record# &nbsp; date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; time &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; name &nbsp; &nbsp;section &nbsp; 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/5/2006 &nbsp; &nbsp; &nbsp; &nbsp;9:50 am &nbsp; &nbsp; &nbsp; &nbsp; david &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/5/2006 &nbsp; &nbsp; &nbsp; &nbsp;3:10 pm &nbsp; &nbsp; &nbsp; &nbsp; john &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/10/2005 &nbsp; &nbsp; 11:00 pm &nbsp; &nbsp; &nbsp; eve &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/18/2006 &nbsp; &nbsp; &nbsp; &nbsp;2:00 pm &nbsp; &nbsp; &nbsp; russ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/18/2006 &nbsp; &nbsp; &nbsp; &nbsp;8:00 am &nbsp; &nbsp; &nbsp; bill &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5/15/2006 &nbsp; &nbsp; &nbsp; &nbsp;9:00 am &nbsp; &nbsp; &nbsp; ken &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5/14/2006 &nbsp; &nbsp; &nbsp; &nbsp;8:00 am &nbsp; &nbsp; &nbsp; liz &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5/15/2006 &nbsp; &nbsp; &nbsp; &nbsp;9:15 am &nbsp; &nbsp; &nbsp; ed &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6
</div>
</div>

I got two tabs in excel:
TAB1 - contains unique record numbers
TAB2 - contains record data.. records are not in order.

In Tab1 I need a formula to show the record number's name and section with the latest date/time. 


TAB1
record#   name   section
1             john         2
2             russ         1
3             ed            6
4
5

TAB2
record#   date               time               name    section  
1             1/5/2006        9:50 am         david        1        
1             1/5/2006        3:10 pm         john          2        
1             12/10/2005     11:00 pm       eve           1          
2              7/18/2006        2:00 pm       russ          1 
2              7/18/2006        8:00 am       bill             2 
3              5/15/2006        9:00 am       ken            3  
3              5/14/2006        8:00 am       liz              5
3              5/15/2006        9:15 am       ed              6

Excel Show latest or lookup

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.