| Home |
| Search |
| Today's Posts |
|
#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
|
|||
|
|||
|
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
|
|||
|
|||
|
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" 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" wrote in message ... 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making used values fall from a list | Excel Discussion (Misc queries) | |||
| How to sum values in multiple worksheets | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Linear Mode
