Comparing 2 workbooks

[Joshua]

I have a list of users on 2 workbooks. I need to compare the 2 workbooks and
see who is one list and not the other. Because of the size of these lists I
could not do it manually. Is there an automated way I could use to do this
and reproduce it on a monthly basis

[Tom Ogilvy]

in an adjacent column

=Countif([Book2.xls]Sheet1!A:A,A1)

drag down the column

repeat in Book2 checking Book1.

then you can filter on the results.

See Chip Pearson's site for working with duplicates and uniques:

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy

"Joshua" <Joshua@discussions.microsoft.com> wrote in message
news:9F47EA6F-313A-489C-A57D-8563F5A5493F@microsoft.com...
> I have a list of users on 2 workbooks. I need to compare the 2 workbooks
and
> see who is one list and not the other. Because of the size of these lists
I
> could not do it manually. Is there an automated way I could use to do
this
> and reproduce it on a monthly basis

[Ron de Bruin]

See all other groups

Please read this
http://www.cpearson.com/excel/newposte.htm




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Joshua" <Joshua@discussions.microsoft.com> wrote in message news:9F47EA6F-313A-489C-A57D-8563F5A5493F@microsoft.com...
>I have a list of users on 2 workbooks. I need to compare the 2 workbooks and
> see who is one list and not the other. Because of the size of these lists I
> could not do it manually. Is there an automated way I could use to do this
> and reproduce it on a monthly basis