Gentlemen and Ladies:
a quick question....i have an excel sheet, with two columns having numeric content.
I want to compare every row from column B against the whole column A to scan if its in that list...if it is, then it should be placed in column C, and if its not, thenin Column D...you get the idea.

Other solution might be, if I can scan for duplicate rows in column A and delete them....does anyone have any scripts or any code that might help me out?

Any help would be highly appreciated...cheers!