Finding the Last Entry Amongst Duplicates

**nbailey** · 10-21-2016, 02:39 PM

Hi,

I need help with a function or formula that will allow me to find the last/most bottom record amongst duplicates, and then to return the rows next to it. For example, referencing the list below, Name, Time and Date are separate columns. What I want the function to do is, when looking for "Tom", for it to return: Tom 1:41 3/24. In my actual data set I have thousands of other records with other names/dates/times. Keep in mind, the "last" record is the highest row value, in this example row 7. Thanks for the help!
A B C
1 Name Time Date
2 Tom 1:33 3/25
3 Jill 1:32 3/22
4 Tom 1:38 3/25
5 Jill 1:35 3/22
6 Jill 1:36 3/25
7 Tom 1:41 3/24
8 Jill 1:40 3/24

**JeteMc** · 10-21-2016, 03:05 PM

Welcome to Excel Forum.
In this solution the name being searched is typed into E2. The time returned is in F2 and the date in G2.
The array entered formula* that populates F2 is

Formula:

Please Login or Register  to view this content.

The cell is formatted h:mm;@
Once the formula is activated* it can be copied across to G2 which can then be formatted m/d;@
*Once you have pasted the formula into cell F2 press the function 2 key (F2), then simultaneously press and hold Ctrl, Shift and Enter. You will then be able to drag the formula across.
Let me know if you have any questions.