PEter,

try to use the "VLOOKUP" function...it will help you to identify with values
are in both tables (sheets)... so you can mark the values that are in both
tables and separete then easily...

i don´t know if you know the VLOOKUP function...if you don´t...check it out
at EXCEL help ...there have a good material about this!

i hope this help you!

Pedro

"Peter Steiner" wrote:

hey just a short question :-D
I have two tables, one with a list with 1330 entries and one with 720
entries, the 720 are all in the big list as well, is there a way to write
the 610 entries from the big list that arent in the small list into another
excel table without doing it one by one ?
thanks in advance
Peter