Hi Parker
See Chip Pearson's Duplicates tips page for a start :
http://www.cpearson.com/excel/Duplicates.aspx
You may then adapt with your own requirements, although I think you will
probably have to use VBA.
If you come to this solution, I recommend you post to
public.excel.programming
HTH
Cordially
Pascal
"Parker" a écrit dans le message de news:
...
I am using excel as 'a diary' with worksheets A to Z as well as a few othre
sheets after Z which are labelled 'sheet', 'sheet1' and 'sheet2'.
In sheet if I enter a phone number or email address, hoe can I check if it
exists anywhere in sheets A to Z ?