Results 1 to 6 of 6

Filter rows and delete duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    04-07-2010
    Location
    Frankfurt, Germany
    MS-Off Ver
    Excel 2003
    Posts
    5

    Post Filter rows and delete duplicates

    Hi, i have this problem:

    i got several thousand data entries with several columns, lets say from A-C.
    In Column A i have an ID which often exists more than once because in column B-C are different comments / entries for that ID.

    Now i got a set of "filter" ID's which i want to use to delete every ROW, which has one of the "to be filtered" IDs in column A.

    Maybe if u look at my sample sheet you will understand what i mean:
    A-C is my data, i want to sort out every row which ID (F-Axxx) exists in column E (the filter criteria)
    How do i achieve that?

    If i use Special Filter it does exact the opposite what i need, it keeps those entries which are found in the category filter and deletes all the rest.

    I would be very glad if someone could help me.
    Thanks a lot in advance!
    Attached Files Attached Files
    Last edited by lunautic; 04-08-2010 at 02:10 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