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.