Home |
Search |
Today's Posts |
#1
|
|||
|
|||
comparing lists
Hi,
I have two lists, placed in two different sheets in the same workbook. Now we want a new list that does only contain those items that are in both lists. Is there a way to do this? Thanks in advance! |
#2
|
|||
|
|||
Check out this site of Chip Pearson.
Scroll down to "D", and see all the options referring to duplicates. http://www.cpearson.com/excel/topic.htm -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Prixton" wrote in message ... Hi, I have two lists, placed in two different sheets in the same workbook. Now we want a new list that does only contain those items that are in both lists. Is there a way to do this? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown lists | Excel Discussion (Misc queries) | |||
Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions | |||
Comparing two List that a "Close" but not Identical | Excel Worksheet Functions | |||
How do I compare two lists of names in excel? | Excel Discussion (Misc queries) | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) |