Good afternoon. I have always used a script which would
look for duplicate entries in a column in excel, but have
lost it due to hardware failure without a backup. What I
used to do was create a new macro and paste the script
into the VB editor.

For it to run, I would need to have my column sorted
ascending and trimmed and it would highlight the
duplicates in that column. Can anyone help me in doing
this same thing or point me in the right direction? I
need the duplicate entries highlighted, not deleted