| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing List A to List B and add what's missing from List B
Hi,
I have workbook with two worksheets. Sheet1 pulls projects with activity and Sheet1 pulls all the projects with and without activity. What I need is a formula or macro that compares sheet1 to sheet2 and returns the projects from sheet2 that do not exist in sheet1. I would like to see those right underneath the list in sheet1. I'm using excel 2007 and the projects format is text. Thank you in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing List A to List B and add what's missing from List B
Gilbert, I posted one possible solution in your other post on this topic:
http://www.microsoft.com/office/comm...94f&sloc=en-us "Gilbert" wrote: Hi, I have workbook with two worksheets. Sheet1 pulls projects with activity and Sheet1 pulls all the projects with and without activity. What I need is a formula or macro that compares sheet1 to sheet2 and returns the projects from sheet2 that do not exist in sheet1. I would like to see those right underneath the list in sheet1. I'm using excel 2007 and the projects format is text. Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| Comparing 2 list | Excel Discussion (Misc queries) | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Linear Mode
