|
|
#1
11-02-2018, 06:08 AM
|
|||
|
|||
How to find and select multiple items / values at the same time in Excel
Here is an over simplified example of my problem
I have 2 excel spreadsheets. The first spreadsheet has 1 column with a list of names John, James, Steve, Richard, Bob The second spreadsheet also has 1 column with a list of the same names, plus some MORE names. John, Karl, James, George, Tony, Steve, Mike, Richard, Bob, Chris I want to find the names in the first spreadsheet, and delete them from the second spreadsheet.. so that the second spreadsheet will be left with Karl, George, Tony , Mike, Chris Find and Select lets me do this, but only one at a time. Is there a quicker way to search for multiple names in one go.. as I have around 1000 to check - thanks. 
|
| Tags |
| find-and-replace, select, vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| append multiple time values to date in one column | sarahafeez | Excel | 1 | 09-25-2017 11:01 PM |
| Select multiple items from a drop down list | ConfuddledOne | Excel Programming | 0 | 01-30-2017 08:13 PM |
| Find and replace multiple values, according to table value - excel formula | EtanM | Excel Programming | 3 | 04-11-2016 01:43 AM |
 How do I find and replace multiple items at once?
|
redzan | Word VBA | 1 | 05-16-2013 08:25 AM |
|
Unable to Select Multiple folders in Outlook 2007 Advance Find
|
gregory | Outlook | 2 | 04-28-2012 10:53 PM |
Windows 10 
Office 2016
Threaded Mode