Remove one smaller database from larger, master customer database

HI,

I have a master customer database with 3300 customer details. I also have a smaller database of about 600 customers, these are included on the master database. Is there anyway I can easily remove the 600 from the 3300? I could paste them together, alphabetise them and manually delete. I have also seen a thread which explained how to highlight using conditional formatting, but this would, as I understand, still require me to manually delete each row. Any suggestions gratefully received!

Just to be clear,each customer is on a row but their data occupies more than one column.

Thanks

Brilliant, thank you very much Fotis1991. You have saved me lots of time and muttering rude words under my breath!

Sir, its really great but i have a small querry that if we have to verfy the data of column A(which contains person name) and Column b(which contains person father name). What formula will be applied , hope i am able to explain you and will be grate full if got a reply with solution. Thanks in Advance.

thank you sir for your advice , i will start new thread and attach a file for reference. I like this site as it is very help full because i have not learned but love to work in Excel as there is so much to do.....Once again Thank You!!

Originally Posted by Fotis1991

greatairi

Welcome to the forum.

We'll be glad to help you but unfortynately you have to start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.