I have that backwards, it should read: If there are duplicates I want them
left in, if the values are unique then I want the entire row deleted.

"helpdesk genie" wrote:

Hi folks,
Here is one that made me go hmmmm.
I have to compare two columns of data. One column has 300 cells; the other
has 1200. If value of colum a matches any value of column b then I want the
entire row that contains that data to be deleted. If there are no duplicates
in the two columns I would like them left alone.
Any help that you can offer would be terrific.