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