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!
Bookmarks