Results 1 to 10 of 10

How to Find the Max and Min Dates from Duplicate Names in a Row and Filter the Names

Threaded View

  1. 01-11-2022, 10:36 PM #1
    elvinayulistia
    elvinayulistia is offline
    Registered User
    Join Date
    02-05-2020
    Location
    Indonesia
    MS-Off Ver
    Microsoft Office 2019
    Posts
    20

    How to Find the Max and Min Dates from Duplicate Names in a Row and Filter the Names

    Hi all,

    I have a data as attached. I have list of repetitive names and dates for each name entry (column A and B).
    I would like to filter the duplicate names and pick up the max date and min date for each name.

    Appreciate if you could help me formulate the column D, E, and F.

    Many thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Populate Calendar (names/Dates) with Names and Dates ranges as data
    By picsou in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-24-2019, 10:37 PM
  2. Double data validation list containing duplicate names to display unique names on dropdown
    By danwoltrs in forum Excel General
    Replies: 7
    Last Post: 12-23-2015, 07:43 AM
  3. Need to copy store names from sheet1 to sheet3 and remove duplicate names
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-21-2014, 08:47 AM
  4. remove duplicate names from different sheets and past only unique names in another sheet
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2014, 09:44 AM
  5. List of unique and duplicate names that correspond with dates
    By corbintx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 01:24 PM
  6. [SOLVED] Retrieve player names from another sheet having a database of duplicate team names.
    By robertooo in forum Excel General
    Replies: 11
    Last Post: 10-21-2012, 01:40 AM
  7. [SOLVED] I need to exclude duplicate patient names for dates of service is.
    By Shannon in forum Excel General
    Replies: 2
    Last Post: 04-10-2005, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1