Natalie has attended:
Excel Intermediate course
Search / Find Function
Hello,
I have a list of 117 people whose names have been split into First Name and Last Names, and I need to search in 17 separate workbooks to see if any of these names are listed. Within the workbooks the names are listed in one cell as a Full Name next to the additional data, rather than separated out into First Name and Last Name.
I started off using the Find function which worked, but this will take far too long with all the spreadsheets and I am sure there must be a way of doing a multiple value search?
If you could help it would be most appreciated :)
Thanks
Natalie
RE: Search / Find Function
Hello Natalie,
Thank you for your question. The easiest method I could suggest, without creating a summary spreadsheet of all the data, would be to place all 17 the Excel files into one folder. When you double-click to open this folder, a search box will appear in the top right corner of the folder window. When you type a name into the search box, Windows will display a list of the Excel file(s) containing that name.
I hope this helps.
Kind regards
Marius Barnard
MS Office Trainer
