does anyone know this formula

[Dylan @ UAFC]

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

 

[Sheeloo]

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]

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

 

[Fred Smith]

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]

=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]

It depends on your definition of "actually typed". If you mean, until
there's something in A1, then use:

=if(a1="","",IF(COUNTIF($A$1:$A$1000,a1)>1,FALSE,TRUE))

Regards,
Fred.

 

[David Biddulph]

But of course the IF(..,FALSE,TRUE) is a long way round.

=if(a1="","",IF(COUNTIF($A$1:$A$1000,a1)>1,FALSE,TRUE)) could be replaced by
=if(a1="","",COUNTIF($A$1:$A$1000,a1)<=1)
as that would similarly return FALSE or TRUE.