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
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
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
>
>
>.
>
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?
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>
>>.
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks