search for same text

L

LinzNac

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
 
G

Guest

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.
 
G

Gord Dibben

anon

Info only.......Excel XP version is Excel 2002.

Newest version is 2003.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Two columns followed by single page-width column on same page 0
Embed the same Excel multiple times 0
Text in note pane of "normal" display suddenly much larger 1
Formating bolded text exclusively. 0
Macro to Select text from a point given to a specific word 2
Color Changing Issues-same document 0

Top