I found a similar post to mine on this forum from back in 2006. It offered a VBA macro to do this, which did not work for me for some reason. I was wondering if there is a new easy way to do this. I'm using excel 2013. I have a value in 2 columns and all I need to do is remove the corresponding UNIQUE values.
For example (123,123) REMOVE, (123,124) Leave.
I tried removing duplicates feature and the filter feature. But this does not work. Remove duplicates only works for duplicates in the same column. But I need to remove duplicates corresponding to unique values in both columns.
More Example Data:
123 123 --- REMOVE 124 128 126 124 --- REMOVE this 124 and matching 124, leave 126 130 140
When Process Finished:
128 126 130 140
Bookmarks