Richard2806
New Member
- Joined
- Oct 28, 2019
- Messages
- 5
Hi Everyone,
I need a little help with something.
I have a report that I get twice a day, on emails that were sent to some of our generic inboxes. Each email has it's own row. Column C of this report contains a list of all the email addresses the email was sent to. There can be one or a number of email addresses in each cell in column C, depending on how many other inboxes the email was sent to, and they are separated by commas. The email may also have been sent to personal or non-relevant inboxes, which I can safely ignore. But this means I can't just search for cells with multiple occurances of the "@" symbol for example, since the email may have been sent to multiple recipients, but only 1 or 2 of the emails are relevant.
So I need to compare those emails addresses against a list of specific email addresses (generic inboxes) in another excel document, where each email address is in an individual cell in column A.
If an email is sent to lets say 2, or 3 of the monitored inboxes, each one will create a job in the system for staff to action, but we really only want one to exist in the system, and that job needs to sit with the correct team for the inquiry. The idea is that I'm comparing where the original email was sent, and if it was sent to more than one inbox, I want to highlight the relevant email addresses, or preferably the entire row in the document so I can follow them up. I'll probably end up hiding all the other rows, to make the report easier to read after it's processed.
The report can be hundreds of lines long, and currently we are going through it manually to look for these emails, highlighting the row where more than one generic inbox is sent to, then sorting the document by highlights, which is taking hours. I want to automate this process.
What I'm looking for is some guidance on what functions would be best to do this.
I've tried things like Match, VLookup, Search, etc. But I'm not able to make this work for me.
Thanks in advance.
I need a little help with something.
I have a report that I get twice a day, on emails that were sent to some of our generic inboxes. Each email has it's own row. Column C of this report contains a list of all the email addresses the email was sent to. There can be one or a number of email addresses in each cell in column C, depending on how many other inboxes the email was sent to, and they are separated by commas. The email may also have been sent to personal or non-relevant inboxes, which I can safely ignore. But this means I can't just search for cells with multiple occurances of the "@" symbol for example, since the email may have been sent to multiple recipients, but only 1 or 2 of the emails are relevant.
So I need to compare those emails addresses against a list of specific email addresses (generic inboxes) in another excel document, where each email address is in an individual cell in column A.
If an email is sent to lets say 2, or 3 of the monitored inboxes, each one will create a job in the system for staff to action, but we really only want one to exist in the system, and that job needs to sit with the correct team for the inquiry. The idea is that I'm comparing where the original email was sent, and if it was sent to more than one inbox, I want to highlight the relevant email addresses, or preferably the entire row in the document so I can follow them up. I'll probably end up hiding all the other rows, to make the report easier to read after it's processed.
The report can be hundreds of lines long, and currently we are going through it manually to look for these emails, highlighting the row where more than one generic inbox is sent to, then sorting the document by highlights, which is taking hours. I want to automate this process.
What I'm looking for is some guidance on what functions would be best to do this.
I've tried things like Match, VLookup, Search, etc. But I'm not able to make this work for me.
Thanks in advance.
