Results 1 to 3 of 3

How to find Duplicates Cluster with Latest Date ?

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    Pune
    MS-Off Ver
    Excel 2003
    Posts
    2

    Unhappy How to find Duplicates Cluster with Latest Date ?

    Hello Everyone,

    I was Stuck where I have three col like Cluster, Dates, Numbers.

    How to find Duplicates cluster which are having latest date and I want Fourth additional col which shows "TRUE" for Latest date and "FALSE" for other having old dates.

    Is there any Macro or Query to find please share ?

    Example:

    Example.jpg

    Example:

    Data like :

    62---3/5/2008---1
    62---9/3/2009---2
    49---1/21/2000---3
    49---1/1/2010---4
    62---1/11/2000---5
    49---3/1/2001---6
    287---3/23/2009---7
    287---12/2/2010---8

    Want OUTPUT like below:

    62__3/5/2008__1__FALSE
    62__9/3/2009__2__TRUE
    49__1/21/2000__3__FALSE
    49__1/1/2010__4__FALSE
    62__1/11/2000__5__FALSE
    49__3/1/2001__6__TRUE
    287__3/23/2009__7__FALSE
    287__12/2/2010__8__TRUE

    Need Help :-)

    Thanks
    Last edited by Swapnil121mali; 01-10-2013 at 06:46 AM.

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