Solved

# Excel Show latest or lookup

Posted on 2006-07-18
174 Views
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
0
Question by:joberl
1 Comment

LVL 6

Accepted Solution

mwharff earned 500 total points
If the table in tab 1 starts at A1 and the table in Tab 2 starts in A1, you need to enter this as an array formula by using CTRL-Shift-Enter after typing the formula.

=MAX(--(A2=Tab2!\$A\$2:\$A\$9)*--(Tab2!\$B\$2:\$B\$9+Tab2!\$C\$2:\$C\$9))

Some other things to be aware of.

The date in column B and Time in Column C need to be in Excel date time values .  Integer for date and decimal for time.

Hope this helps.

Mike
0

## Join & Write a Comment Already a member? Login.

### Suggested Solutions

A short article about problems I had with the new location API and permissions in Marshmallow
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

#### 743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

#### Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!