Excel Issue

[Audicab]

Hopefully somebody can help me as I am going mad.

I am trying to de-dupe a list in Excel of our prospects. I have a spreadsheet of 8000 rows which includes multiple contacts at the same company.

I then have a list of 1000 companies that I need to remove all contacts from the spreadsheet.

I can't just de-dupe it as it will remove all companies, not just those on the list of 1000, unless they have just 1 contact.

The only way I have thought of is to manually go through and match them up but this is obviously time consuming and open to errors.

I hope I have explained that and if anybody has any help that would be great.

Thanks

[Audicab]

wsurfa said:

You may need to explain better as the above just looks like a vlookup to your 1000 company remove list to add a column with 'delete', then simple filter by 'delete', delete, which then removes the 1000 companies

I am hoping it is very simple, would a vlookup delete all instances where my main database matches any on the 1000.

To explain a little, my prospect spreadsheet contains 8000 peoples names at 2000 companies. I then have a list I am trying to match which just contains 1000 company names.

I just need to identify all contacts from the prospect list at the 1000 new companies.

[Audicab]

2010

[Audicab]

mrmr96 said:

Have I got this right:

Sheet 1 contains 8000 rows, with more than one row per company (one for each contact).
Sheet 2 contains 1000 rows, with one row per company (?) of lost customers.

You need to remove all entries on Sheet 1 if the company exists on sheet 2?

Yes exactly this, thank you.

In answer to the question above by Paul, the unique identifier is the company name

[Audicab]

That is fantastic thank you. I have a few of these to do over the next few days and you have saved me time and from going mad.