Don't know if this will solve your problem or not, but there is an easy way
to get rid of duplicate entries. Highlight the range of phone numbers
including the header row, go to Filter, Advanced. There should be a cell
that says to copy to another place, click that and tell it where you want to
put the entries, then there is a box that says "Unique Entries Only" (or
something like that). Click that and then hit OK. The new list will
contain only unique entries.


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