Find Unique Values

Using Conditional Formatting

If Range is A:A, select that range, open Conditional Formatting and select "Formula Is", then enter

=COUNTIF(A:A,A1)=1

Choose whatever format to show unique values (A1) you prefer



© Copyright andrewsexceltips.net. All Rights Reserved.