Excel - values in two workbooks 1

[RITec]

I have two Excel workbooks and I need to compare Column “A” in both workbooks.

What I need is to know which numbers are in column "A" of book1 that are not in column "A" of book 2, and I need to know which numbers are in column "A" of book 2 that are not in column "A" of book 1.

Any help is much appreciated.

Thanks in advance

RITec

 

[SkipVought]

Hi,

In and empty adjacent column on the sheet in wbk1, enter the following formula...

=COUNTIF(

at this point, switch to wbk2 and select the entire colum of data you want to compare to. Your formula should look somwthing like this so far...

=COUNTIF([Book2]Sheet1!$A$1:$A$33

Enter a comma and then click in the first cell of column A...

=COUNTIF([Book2]Sheet1!$A$1:$A$33,A1)

Now copy that formula down.

Do the same this in wbk2 and...
VOLA!
Hope this helps Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[RITec]

Thank you

Just what I needed.


Skip


a start for you too.