Finding Duplicate enties & highlighting

M

mchugo

I am trying to configure a spreedsheet that will have multiple person
phone number entries in groups of columns with the owners name ontop o
that column. I want to be able to create a formula or macro that ca
search the entire sheet or sheets comparing column(person phon
entries) to column (person phone entries) and highlighting the number
that are duplicated.

Ultimately i would love if i could produce a results sheet that tell
me which persons phone list has the same number as another person
phone list. Is this possible, this would mean alot to me to get thi
working
 
Top