I have a few question I am currently using
=if(COUNTIF($b$1:$B$20000,b1)1,"TRUE","FALSE")

When Copy down FALSE will display until it checks for the dup
how can I get the cell remain blank until the date is entered.
Then If possible how could we have the TRUE render in Green
and the FALSE render in Red.

If you are up for a chalange.
If there any possible way to have the TRUE or FALSE hyperlink
you to the place in the worksheet were the duplicated value exisist

"Chip Pearson" wrote:

These formulas assume that your phone numbers are in A1:A10 and the
formulas are entered in B1:B10.

If you want to mark only duplicated items (e.g., if 123 appears three
times, only the second and third instances are marked as duplicates--
the first instance is not marked), enter the following formula in B1
and fill down to B10:

=IF(COUNTIF($A$1:A1,A1)1,"duplicate","")

If you want to mark all items that have duplicates (e.g,. if 123
appears three times, all three instances are marked as duplicates),
enter the following formula in B1 and fill down to B10:

=IF(COUNTIF($A$1:$A$10,A1)1,"duplicate","")

With both formulas, duplicates are marked by the word "duplicate" in
column B, or if the value in column A is not a duplicate, the cell in
column B will be empty.

Change the cell references to your needs. Note, though, that you must
include the $ characters as shown above. If you omit the $ characters,
the formulas will not work properly.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Fri, 12 Dec 2008 22:13:01 -0800, Dylan @ UAFC
wrote:

looking for a way to check for
duplicates in a range
and
say column is list of unique phone numbers
is there are function that would display in a corsiponding
cell to let the data entry know if there is the phone
number is bring duplicated
don't care about highlighting anything