Creating Multiple Results from two text columns that have repetitive info

[chefpryan]

Hello,

I'm not sure what I'm trying to do is even possible, but figured this is the place to ask the question. I'm trying to compare a list of companies (column a) to a list of employee email addresses (column b) and post results (column c) that display all associated email addresses that are unique to company name. Since multiple employee email addresses can be associated with numerous company names, I'm unable to figure out what is the best approach.

Any suggestions/examples would be very much appreciated.

Thanks

[crzu]

@chefpryan

Welcome to the forum.

My understand on your request is that you will wish to have a formula to check if the email and company name is unique?

This type of request requires a human judgement. Human judgement had many of their own criteria to decide. If you could list out every detail of such criteria, you could make it into a formula.

However, for your case, it is too complicated.

If you like to extract the word between @ and .com from the email, formula is possible.

For example, [email protected]

The word between @ and .com is acme. It is possible to extract "acme" out of the email. To do a match against the company name would be complicated.

[VKS]

Hello Chefpryan,
Is this the complete list? currently it has only 12 companies showing more than one enteries (2 email ID's)
ARNOLD R. STREISFELD, ESQ
ASSURANT SPECIALTY PROPERTY - REAL ESTATE SECURED LOAN INSURANCE SERVICING
COLLABERA, INC. - IT PROFESSIONAL SERVICES
CORELOGIC - REAL ESTATE SOLUTIONS
DELL SECUREWORKS - MANAGED SECURITY SERVICES
DIGITAL MATRIX SYSTEMS - DMS CONSUMER ORIGINATION SCORECARD PROJECT
INFORMA RESEARCH SERVICES - COMPETITIVE DATA
ION INTERACTIVE INC - SOFTWARE FOR LAUNCHING LANDING PAGES
MPHASIS - MULTIPLE SVCS FOR TECHNOLOGY DEVELOPMENT
NIIT TECH - IT SERVICES PROVIDER
SUNGARD AUTOMATED SECURITIES CLEARING LLC - PROTOGENT PTA SERVICE
THOMSON REUTERS - FIDUCIARY TAX RETURNS
Thanks/VKS