try data validation

--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"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