+ Reply to Thread
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

  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

  2. #2
    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.
    Last edited by AB33; 10-24-2018 at 04:33 PM.

  3. #3
    Forum Contributor
    Join Date
    05-08-2013
    Location
    FLORENCE, ALABAMA
    MS-Off Ver
    Excel 2010
    Posts
    120

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

    Hello AB33,
    Thank you so much for the help. It worked perfectly. You have been a wonderful help on a few other request of mine in the past. I really... really do appreciate all your help. I will close out this request. If you have a chance, I have another request called "How to Pull line data under a heading name", that I don't seem to have anyone able to help me with that request. It is a little more odd then this was. I am sure it can be done but I haven't been able to find any searches on how to look for a suggestion.

    Once again..... THANK YOU FOR THE HELP!!

  4. #4
    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

    Hello Tammy,
    I am a bit tied up tonight— will have a look tomorrow.

+ 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. 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