Compare colums

[Thomas Tromp]

Hey everyone,

Can somebody help me.
I've got 2 books an old and a new one, filled with numbers.
I want to track the numbers that are new in the new book.

like this.

book1 book2
1 1
2 2
3 3
4 4
5 5
6

I want to return the number 6 cause this number is new.

thanks for the help

thomas

 

[thomas]

Found the answer

=IF(ISERROR(MATCH(A1,$D$1:$D$7,0)),"Missing","")

ciao