know im being picky but
any way to have the true display in green and
the false diplay in red,
and then wold it be possible to
have the word trueor false hyperlink you
to the place in the sheet were the duplicate is

"Sheeloo" wrote:

If your values are in Col A then use this in B1 and copy down

=IF(COUNTIF($A$1:$A$100,A1)1,True,False)

or

=IF(COUNTIF($A$1:$A$100,A1)1,"Duplicate","Unique" )

"Dylan @ UAFC" wrote:

Column A B C
(999) 000-0000
(999) 111-1111 TRUE (can this check the array for
duplicate and
render true if no
dup exists in the range
(999) 111-1111 FALSE (can this check the array for
duplicates and
render FALSE is
there is in fact a dup...

any suggestion