Hi Everyone,
I need to design a filter to be used in the following way:
A B
1234 Edgington
1234 Paramount
0756 Dummy
I have two columns of Data that I want to primarily focus on in this filter. As you can see in column A is a generic reference number and in column B is a name associated with that reference number. What I want to do is eliminate the duplicate entry associated with the same number referenced in Column A. In this case I would want to have the bottom entry associated with the same generic number removed. I was thinking is there some kind of 'if' logic that I could use. Some thing like if A1 and A2 are equal and B1 and B2 are not equal then delete line 2. Also, I need the filter to not delete items which have different reference numbers. So included in there should be something like if A2 and A3 are not equal no not delete A3.
Hopefully that made sense. Any help on this is greatly appreciated as I am a relative new comer to working seriously with Macro's.
Thanks
Bookmarks