list values equal in 2 worksheets?

[NEVA LOCKETT]

How can I get a list of all rows containing data that is also in another
worksheet.

In both sheets there is a number, name, address etc. I want a list of only
those rows that occur in BOTH sheets.

Can someone help please?
NL

 

[Biff]

Hi!

Need more detail ....

Specific locations of data in both sheets ...
Is the number , name , address etc all in a single cell?

Biff

 

[NL]

Thanks for your reply!

I did figure this out! But I have another problem not solved.

First the figure out:
the number , name , address etc ARE in separate cells. I used this formula:
=OR(EXACT(Sheet1!A1, Sheet2!$B$1:$B$15)) which worked in my test sheets.

Other problem:
I want to make mailing labels efficiently.
There are many instances of multiple names at the same address
bob/smith/100main/...
pam/smith/100main/...
sue/jones/100Main/....

Is there a way to extract a list of all combined multiples so there is ONE
Smith instance at 100 Main AND one Jones? (bob and pam as one instance, then
sue listed as a second instance) Bob and Pam could then be replaced as
"Family of" and Sue would remain "Sue".

Hope this makes sense...
NL





----- Original Message -----
From: "Biff" <[email protected]>
Newsgroups: microsoft.public.excel.worksheet.functions
Sent: Tuesday, February 22, 2005 10:31 PM
Subject: list values equal in 2 worksheets?