hi,
see this site.
http://www.bmsltd.ie/MVP/
they have a free addin utility call flexfind that will
search all sheets for selected text or numbers.
this utility is built into xp and above. not sure about
2002. i jumped from 2k to xp.

-----Original Message-----
If there a way to tell excel to search within the same
workbook for
multi-entry of same text. Want I'm trying to do if check
to make sure that
the spreedsheet doesn't have double entry of the same
information. Can excel
do that and if so how do I make it happen?
Thanks to anyone that replies
.