# list values equal in 2 worksheets?

1. ## list values equal in 2 worksheets?

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

2. ## list values equal in 2 worksheets?

Hi!

Need more detail ....

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

Biff

>-----Original Message-----
>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
>
>
>.
>

3. ## Re: list values equal in 2 worksheets?

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" <biffinpitt@comcast.net>
Newsgroups: microsoft.public.excel.worksheet.functions
Sent: Tuesday, February 22, 2005 10:31 PM
Subject: list values equal in 2 worksheets?

> Hi!
>
> Need more detail ....
>
> Specific locations of data in both sheets ...
> Is the number , name , address etc all in a single cell?
>
> Biff
>
>>-----Original Message-----
>>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" <biffinpitt@comcast.net> wrote in message
news:036b01c51960\$928ce830\$a401280a@phx.gbl...
> Hi!
>
> Need more detail ....
>
> Specific locations of data in both sheets ...
> Is the number , name , address etc all in a single cell?
>
> Biff
>
>>-----Original Message-----
>>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
>>
>>
>>.
>>

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1