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. #1
    Forum Contributor
    Join Date
    05-08-2013
    Location
    FLORENCE, ALABAMA
    MS-Off Ver
    Excel 2010
    Posts
    120

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

    Hello VBA experts,
    I have a macro that looks for the unique value in col A and then looks at the most recent date in col B, then it deletes the rest. I am needing the macro to look for the unique value in col A & C and look for the most recent date in col B. Delete the rest. Would someone be so kind and look at my macro and help me add the second unique value to the macro? Please and thank you so very much. Thanks!!!!
    Attached Files Attached Files

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1