=IF(COUNTIF($A$1:$A$1000,a1)1,FALSE,TRUE)
any way to write this where the cell
does not display FALSE or TRUE until the data
is actually typed

"Fred Smith" wrote:

You can color the True/False results by using Conditional Formatting (in the
Format menu).

The hyperlink is a lot more difficult, because there can be more than one
duplicate. The easiest way to display the duplicates is to Filter them (in
the Data menu). Just select all the Trues to see duplicates, then select an
individual phone number.

Regards,
Fred.

"Dylan @ UAFC" wrote in message
...
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