Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Advanced Search (Feature/Option/Plug-in)
How can i search more than one string within an excel work. i.e i could have
the string "100" 3 of the sheets and "200" in one of the sheets. I would like to search for both "100" and "200" within my excel work-book. Is there any free-plugin or other add-on softwares with excel that provide for the same ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Advanced Search (Feature/Option/Plug-in)
Hi,
In my opinion, you should write a simple macro to do this. "Safal" wrote: How can i search more than one string within an excel work. i.e i could have the string "100" 3 of the sheets and "200" in one of the sheets. I would like to search for both "100" and "200" within my excel work-book. Is there any free-plugin or other add-on softwares with excel that provide for the same ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Advanced Search (Feature/Option/Plug-in)
In xl2k and below, you can group the sheets you want to search and do an
edit|Find (one value at a time). In xl2002+, you can specify that you want to search the whole workbook (still one value at a time). In all versions of excel, you could use Jan Karel Pieterse's FlexFind: http://www.oaltd.co.uk/MVP/ But all work one by searching for one value at a time. Safal wrote: How can i search more than one string within an excel work. i.e i could have the string "100" 3 of the sheets and "200" in one of the sheets. I would like to search for both "100" and "200" within my excel work-book. Is there any free-plugin or other add-on softwares with excel that provide for the same ? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel search function | Excel Discussion (Misc queries) | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Search multiple worksheets - Excel 97 | Excel Discussion (Misc queries) |