Results 1 to 4 of 4

Duplicate Entries need to be Deleted after checking Date

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    berlin
    MS-Off Ver
    Excel 2010
    Posts
    10

    Duplicate Entries need to be Deleted after checking Date

    HI
    I hope an easy Question:
    My XL sheet has Duplicate entries what i need "Prune" according to the Latest EXPiry Date.
    -
    The Sheet is sorted by KNUMBER.
    After an update from another File.It happens that there are multiple entries (every Week)!

    I need to DELETE these entries from this sheet (the MASTER)
    Any KNUMBER (Customer Number)that has a LATER EXP(iry) Date Remains
    Can anyone help me with this..
    I attach the Small file .
    Many thanks in Advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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