Best way to mass search a list on another list :)

[BowerZ]

Soo I have "The list"

I have a list of Emails

I want to select lines that contain that email and extract them onto another sheet.

Any people know of a way?

Kinda pulling my hair out of this one.

[PrettySarcastic]

@BowerZ ([Only registered and activated users can see links])

Kind of depends. I have never seen the magic list.

If it's in Excel format (or Google Sheets), this could probably be done with some snazzy formulas.

I'm pretty good in Excel, so if so, let me know if I can assist. :)

[Jumbo Shrimp]

why not just have the usernames sent to the email?

[Salivating Slorg]

Copy both lists into an excel spreadsheet. highlight all the data, click Conditional Formatting → Highlight Cells Rules → Duplicate Values

Click ok, Bam.

Should highlight the cells of all the duplicate emails in the list

[j03]

Need more detail to your post... Some of the responses on this topic don't relate at all to what you asked me via PM, assuming it's the same scenario. :P

Maybe share some code that you've already tried so we can work with something.

[BowerZ]

You are correct joe it is the same as what we discussed, but PrettySarcastic the legend managed to assist me and come up with a beautiful system using excel to sort it!

But thanks to those who tried to help!