+ Reply to Thread
Results 1 to 2 of 2

Need Macro that will pick multiple criteria from duplicate values

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    AUCKLAND NEW ZEALAND
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need Macro that will pick multiple criteria from duplicate values

    Hi folks,
    need a macro or function that will recognize a duplicate and take a value from the last duplicate add it next to the first and delete extra duplicates.
    there could be 2, 3 0r 4 duplicates
    ie

    Column A Column B Column C
    REGO START DATE END DATE

    EFG001 01/08/12 07/08/12
    EFG001 08/08/12 18/08/12

    I would like this left
    EFG001 01/08/12 18/08/12

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,690

    Re: Need Macro that will pick multiple criteria from duplicate values

    Hi
    try this:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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