Identify and Highlight Duplicate and Unique Data in Excel with Python

When registration forms from several channels are merged, a repeated email address usually means someone submitted twice. When an inventory list is reconciled, a duplicated product code means the ledg