Can this be done more efficiently in Acess?

[PropertyGuy]

I am currently using excel to compare one column of data to the other to determine what is in column A that's not in B and having it show me the numbers with the following formula below
=IF(COUNTIF(B:B,A2),"",ROW())
=IFERROR(SMALL(C:C,ROWS($1:2)),"")
=IFERROR(INDEX(A:A,SMALL(C:C,ROWS($1:1))),"")

The problem is 85k lines vs 84 k lines is a bit more than my computer can handle at times and is either really slow or gives up. Another person in my organization claims to do this simply with access but of course won't share how she does it. Any help would be appriciated.

[maw230]

I think Access would be much more efficient, but the only way to find out is to try. Just import the data into an access table. Then write a simple select query like:

Please Login or Register  to view this content.

or you might need a nested select query like:

Please Login or Register  to view this content.