how do i compare two excel spreadsheets to indicate differences

I am using excel 2000 and have two spreadsheets with company name address etc
.. I want to be able to put the two spreadsheets into one spreadsheet but be
able to see/have a column indicating the duplicates or be able to filter out
the duplicates.
Many thanks

see www.cpearson.com where Chip has lots about duplicates
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Paul123" <Paul123@discussions.microsoft.com> wrote in message
news:8C7F6978-885F-4A78-89D5-C1D9E5F53B5B@microsoft.com...
>I am using excel 2000 and have two spreadsheets with company name address
>etc
> . I want to be able to put the two spreadsheets into one spreadsheet but
> be
> able to see/have a column indicating the duplicates or be able to filter
> out
> the duplicates.
> Many thanks
>