Results 1 to 4 of 4

Look for unique value in col A & col C then find most recent date in col B. Delete rest

Threaded View

  1. 10-24-2018, 04:31 PM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Look for unique value in col A & col C then find most recent date in col B. Delete re

    Try the attached.
    Attached Files Attached Files
    Last edited by AB33; 10-24-2018 at 04:33 PM.
    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. Find Most Recent Date corresponding to Unique ID from Multiple Workbooks
    By NATANI in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-02-2018, 06:03 AM
  2. Return most recent date for each unique ID
    By spot2018 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2018, 11:55 PM
  3. pivot table unique rank by most recent date
    By ammartino44 in forum Excel General
    Replies: 2
    Last Post: 01-15-2018, 07:19 PM
  4. [SOLVED] Formula to identify a unique number and its most recent date
    By Excel Analyst in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-15-2013, 04:51 PM
  5. How to find duplicate entries, find which has the lowest value, and delete the rest?
    By John2810 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-05-2011, 06:39 AM
  6. Macro : To find word and Select rest after this cell and delete rest
    By Zortabello in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2010, 08:06 AM
  7. Find the Latest date and delete the rest
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2009, 05:13 AM

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