| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search text in other workbooks
Hi,
I wonder if someone can help me out. I have various excel files of book listings. I would like to have a spreadsheet that can search column B in all workbooks for a specific book title, then tell me which workbook the book title is in and the row number if possible. Also can it find duplicate names as well, thanks in advance for your help. I would then do the same for the author. John T. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search and open excel workbooks from a master workbook | Excel Discussion (Misc queries) | |||
| search and link workbooks | Excel Discussion (Misc queries) | |||
| Fun with text functions - search for text | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| search through workbooks | Excel Worksheet Functions | |||
Threaded Mode
