I know I can use conditional formatting to highlight duplicate entries. If I was typing it, Excel would auto complete, so I know an entry exist. However, most of my input for this specific Excel spreadsheet is copy/paste. Is there anyway to know an entry is duplicate other than using conditional formatting or sorting?