+ Reply to Thread
Results 1 to 4 of 4

How to combine identical entries with different dates to reflect the latest date

  1. #1
    Registered User
    Join Date
    01-10-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to combine identical entries with different dates to reflect the latest date

    Hi Guys,

    I've an excel spreadsheet that has thousands of names (speadsheet from HR Department).

    This spreadsheet contains each individuals Leave Entitlement (Leave codes).
    However, there are lots of duplicates as there are multiple updates on different dates.

    I would want a formula to display the latest date with Leave Entitlement tag together.
    I was thinking through using Vlookup with SUMPRODUCT but cant seem to achieve the result.

    I've attached the spreadsheet for easier understanding of what I'm trying to say.

    Thanks in advance for those who've rendered assistance!

    Leave Grades.xls
    Last edited by Pr0ph3ts2; 01-11-2012 at 03:11 AM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Need help in Formular

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    01-10-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need help in Formular

    noted. have amended accordingly. hopefully its clear enough

  4. #4
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: How to combine identical entries with different dates to reflect the latest date

    Put this formula in I2 -
    Please Login or Register  to view this content.
    All the 0 need to be deleted. The cells containing 1 is what you need after the deletion.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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