Hi all,

I have got 2 sets of numeric data in 2 columns:

Column A Column B Column C (desired result) Column D (desired result)
001 002 001 A
002 003 004 A
003 005 005 B
004 006 007 A
006 008 008 B
007 009 015 A
009 016 A
015
016

I am looking to identify number in Column C that is Unique and write a comment "Column Name" (to which Column data set the unique data belongs) in Column D. Appreciate your help for excel formula and/or VBA code.

Thank you
Roshan Shakya