Compare cells and remove row

Hey guys,

I have a fairly basic macro that I need help solving. My goal with this macro is to run a loop that compares two columns of data removing any names that are unique from the first (shorter) column. Essentially this will be scrubbing a short list of names against a full roster of people. I would like for the entire row to be deleted upon finding that it is unique as well. This is what I have so far but it's not working as intended. I've attached a summarized version of what is needed as well. Don't pay any attention to the arr variable as this will change in the actual worksheet. Thanks for all help in advance!RC_Example.xlsx

Please Login or Register  to view this content.