The following video will demonstrate you how to select the unique values within a range in Excel by using ASAP Utilities.

The video demonstrates how to select the color names that appear only once in the list:

Note: This old video is no longer available and will in 2021 be replaced with a new version in a modern version of Excel.