Advance Filtering Problem

Abbas999

Board Regular
Joined
Jan 4, 2015
Messages
102
Hi Guys,

I am trying to clean up an excel spreadsheet. It has 4500+ entries. Important columns are:

Company Name
Contact Name
Email Address


It has mixed email addresses i.e info@ sales@ admin@ marketing@ support@ and Personanme@example.com
I want to clean the whole sheet for these generic email addresses and keep them only with person name email addresses.

I have managed to apply simple filters and removed generic emails "info@ sales@ admin@ marketing@ support@" but there are many other custom email addresses that needs to be moved to another. they are all different but generic so need to move these to another sheet where i already put these generic records. I want to move full row not only a cell "email". Some of the bad records are:

ABCDEFGH
3rd Strike Performance409 County Hwy 448SikestonMODuane GarrettOwner3rdstrike@charter.net
3SX Performance Automotive Inc.4494 Raceway Dr.ConcordNCStephen BurrowsPresidentonlinestuff@3sxperformance.com
4 Wheel Center Inc.7210 Gateway Blvd. EEl PasoTX 79915-1301Carlos EnriquezPresidentwfour@elp.rr.com
4 Wheel Online5911 Benjamin Center Dr.Tampa,FLRyan HeathPresidentmanagment@4wheelonline.com

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]23[/TD]

[TD="align: right"]63801[/TD]

[TD="align: center"]24[/TD]

[TD="align: right"]28027[/TD]

[TD="align: center"]25[/TD]

[TD="align: center"]26[/TD]

[TD="align: right"]33634[/TD]

</tbody>


In Simple - I want to filter by email address and Contact name matching. I.e
If Contact name is John Smith and Email include his name or starting with Smith or has smith in the email I would like to filter it. At the moment there are about 2900 records in total which i need filter applied. I have already filtered the most generic email addresses.

Good records example:

ABCDEFGH
1474773 AB Inc.5414 Rue EaglemontBeaumontAB /CAT4X 0H2Dave HubertOwnerD.hubert@gmx.com
180 Degrees Automotive545 W Mariposa St.PhoenixAZBogi LateinerPresident, Master Mechanic, EducatorBogi@180auto.com
1932 Deuce Coupe LLC1200 Orange Camp Rd.DelandFLRobert FortnerPresidenthotrod.robert@hotmail.com
1ShopAuto1100 Merlene Dr.Austin,TX Alan BrownCEOAlan@1ShopAuto.com

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]85013[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]32724[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]78732[/TD]

</tbody>

Thanks in advance
 
Last edited:

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top