View Single Post
  #5   Report Post  
jerry_maguire jerry_maguire is offline
Junior Member
Posts: 25
Default Try this simply

To filter for unique values, click Data Sort & Filter Advanced. To remove duplicate values, click Data Data Tools Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.