Best way to mass search a list on another list :)
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.
why not just have the usernames sent to the email?
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
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.
Maybe share some code that you've already tried so we can work with something.
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!
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules