I'd start with a VLOOKUP in column C, and if the VLOOKUP of the value in column B is found in column A, you know it's duplicate. Then in columns E & F, you can say if the VLOOKUP value was an error (or use IFERROR with your VLOOKUP to make it whatever you want), then equal A or B respectively, if not, equal blank.