+ Reply to Thread
Results 1 to 6 of 6

Show latest date of multiple records

  1. #1
    Forum Contributor
    Join Date
    06-18-2013
    Location
    Detroit, MI - USA
    MS-Off Ver
    2016
    Posts
    235

    Show latest date of multiple records

    See the attached example.. what function can I use to filter out only the latest record (by date)?
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Show latest date of multiple records

    How about with a pivot table?

    Put a header in A2, A3, and A4

    In A4, a new column...

    =MAX(IF($A$3:$A$13=A3,$B$3:$B$13)) >> Enter with Ctrl + Shift + Enter

    Now create a pivot table and add the first and second column as Rows
    HTH
    Regards, Jeff

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Show latest date of multiple records

    You have a few options. Here are two:

    A) Create a PivotTable using Min of Date (format number to show as a date). This will require that you give your data headers (not a single merged cell as in your example).

    B) Copy and paste column A into a new column (let's say column D) then remove duplicates on column D (this step can also be done through a formula if you want). Now put this formula in E2:

    =MIN(IF(A$2:A$12=D2,B$2:B$12)) Ctrl Shift Enter

    See attachment for clarification.
    Attached Files Attached Files

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Show latest date of multiple records

    Whoops... I thought that you said earliest dates for some reason.

    Just switch MIN to MAX in the formula (or PivotTable if you want to go that route).

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Show latest date of multiple records

    Because you've Ex2016 and built-in PowerQuery (Get&Transform) you can try with Grouping by Person and Max for Date column

    Change/Add/Remove something in source table then right click on result table and refresh
    Attached Files Attached Files
    Last edited by sandy666; 10-12-2017 at 03:04 PM.

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Show latest date of multiple records

    Thanks for the rep! I am assuming that one of our responses answered your question?

    If so, please mark this thread as SOLVED.

+ 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. Replies: 4
    Last Post: 02-08-2015, 06:37 PM
  2. Need help to show only the latest date
    By stuhico09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2015, 04:00 AM
  3. [SOLVED] Formula required to return 2 latest records in a date range
    By Backroomgeeza in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 10-23-2012, 05:53 AM
  4. retrieve the latest date from list of records
    By bajdr47 in forum Excel General
    Replies: 1
    Last Post: 09-23-2010, 12:42 AM
  5. show the latest date automaticly
    By JustinBourne in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2007, 02:12 AM
  6. count unique records with latest date
    By xtrmhyper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2005, 07:05 AM
  7. latest date & project records
    By lhs42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2005, 02:07 PM

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