Hi,
I have an excel file with a bunch of numbers in row A and a bunch of numbers in row B


I want to find which numbers in row B do not appear in row A


how do I do that?

There's this.

http://www.merawindows.com/Forums/tabid/324/forumid/90/postid/33337/scope/posts/Default.aspx

Or this.

http://www.canadiancontent.net/tech/download/Excel_List_Compare.html

I believe both are different ways of achieving the same goal.

Love this van sometimes.

Simplest way is to type into cell C1, =VLOOKUP(B1,A:A,1,0)

If it returns an error, the number is not in column A

You can pretty it up by putting it in an IF statement, =IF(ISERROR(VLOOKUP(B1,A:A,1,0)),"Is Not Repeated","Is Repeated")

Or something similar...

Cheers - that did the job!