I have got 2 excel sheet. Both have the same formatting and column HEADING etc. Lets call it Table1 and
Table2.  

Table1 contains Tables 2 + other entries (and entries are mixed) eg:

Table 1:
Name   Date     Time     Class
Bob      16 Jan   12.30    English
Tim      12 Mar   12.30    Maths
Dom     14 Jul    12.30    Science
Rob      18 Dec   12.30    PE
Pete     17 Jan    12.30    English
Sam     17 Feb   12.30     French

Table2 contain some of the entries in Table1 eg:

Table2:
Name   Date     Time     Class
Bob      16 Jan   12.30    English
Dom     14 Jul    12.30    Science
Sam     17 Feb   12.30     French

I want to remove table2 entries off table1.Both the tables have thousands of entries. What is the best way of removing the content of table2 off Table1 so that Table one end up looking like this:


Desired outcome of Table1:
Name   Date     Time     Class
Tim      12 Mar   12.30    Maths
Rob      18 Dec   12.30    PE
Pete     17 Jan    12.30    English



What is the best way of going about it? Please HELP. ThanksI would use Access to do this.  I realize you may not have Access or, if you have it, you may not be familiar with it, so my suggestion may not appeal to you.  

I would import the Excel tables into Access tables, then use a Query in Access to compare the two tables and produce the list you want.  Then, that Query can easily be exported back to Excel.  If you want more details on this, let me know.

As far as doing it in Excel, I don't know how to do that.  I have some doubt that it can be done, but I'm just not sure.  How many entries (row/column) you have in both tables?
It seems that the entries in Table 2 is duplicated in Table 1.
Is the data sorted in any way?

If there are not many entry and the data is not sorted, what I normally do, manually, is to put condition in a blank column and sort the data by the outcome of the condition then delete all the corresponding rows.

You know how to use VLOOKUP ?Thank you both for your help. Unfortunately, the data is not sorted and table1 has over 60000 entries and table2 has around about 5000 entries.

 I tried putting a condition on the blank columns and was able to reduce some of the entries. Now I am looking into access to reduce it further.

Thanks.  


Quote

Unfortunately, the data is not sorted and table1 has over 60000 entries and table2 has around about 5000 entries.