+ Reply to Thread
Results 1 to 3 of 3

Finding the Last Entry Amongst Duplicates

  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    San Francisco
    MS-Off Ver
    2013
    Posts
    1

    Question Finding the Last Entry Amongst Duplicates

    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

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    15,076

    Re: Finding the Last Entry Amongst Duplicates

    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: copy to clipboard
    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.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Finding the Last Entry Amongst Duplicates

    Here's another one...

    Data Range
    A
    B
    C
    D
    E
    F
    G
    1
    Name
    Time
    Date
    ------
    Name
    Time
    Date
    2
    Tom
    1:33
    3/25
    Tom
    1:41
    3/24
    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


    This formula entered in F2 and copied across to G2:

    =LOOKUP(2,1/($A$2:$A$8=$E2),B2:B8)

    Format the cells as needed.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to count only the first entry and not the duplicates
    By adamtv1111 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-25-2016, 12:07 PM
  2. Finding Duplicates - Then finding delta
    By meppwc in forum Excel General
    Replies: 1
    Last Post: 09-30-2015, 04:10 PM
  3. [SOLVED] Select every second entry, no duplicates
    By ANDREAAS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2015, 02:31 AM
  4. Replies: 2
    Last Post: 12-27-2013, 09:24 AM
  5. I want find duplicates entry after first entry in list b from list a
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2013, 05:47 PM
  6. [SOLVED] Duplicates entry
    By mdshotgun in forum Excel General
    Replies: 7
    Last Post: 05-22-2012, 11:03 PM
  7. Finding duplicates in list during UserForm entry process
    By excelnut1954 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2006, 10:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1