Find and Pull Out Multiple Records

[NT80P]

Hi Forum,
I have a list of 24 names, and I have a spreadsheet with thousands of records, the 24 names show up multiple times within that sheet. Rather than searching 24 times for all the records with that name. I'm trying to create a formula that will find all the rows that have one or more of 24 names and highlight them so they can be dumped into their own spreadsheet.

I hope this makes sense. I'm using Excel 2010. As always thank you for your ability to solve things when my mind turns to mush!

 

[Aladin Akyurek]

Hi Forum,
I have a list of 24 names, and I have a spreadsheet with thousands of records, the 24 names show up multiple times within that sheet. Rather than searching 24 times for all the records with that name. I'm trying to create a formula that will find all the rows that have one or more of 24 names and highlight them so they can be dumped into their own spreadsheet.

I hope this makes sense. I'm using Excel 2010. As always thank you for your ability to solve things when my mind turns to mush!

If you would want to use formulas, you could try to adapt post #3 from:

http://www.mrexcel.com/forum/excel-questions/307832-multiple-vlookups.html#post1511354

 

[T. Valko]

Hi Forum,
I have a list of 24 names, and I have a spreadsheet with thousands of records, the 24 names show up multiple times within that sheet. Rather than searching 24 times for all the records with that name. I'm trying to create a formula that will find all the rows that have one or more of 24 names and highlight them so they can be dumped into their own spreadsheet.

I hope this makes sense. I'm using Excel 2010. As always thank you for your ability to solve things when my mind turns to mush!

Maybe this...

Lookup when there are multiple instances of the lookup value