| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
want to find what project is not on one list
I have two lists, the unique field to both lists is the text(project name).
How can I find what is not the same(meaning what is being left out)? thanks Jerry |
|
#2
|
|||
|
|||
|
Jerry
If one list is in A1:A100 on sheet1 and the other the same range on sheet2 then in B1 on sheet1 enter =COUNTIF(Sheet2!$A$1:$A$100,A1) Should return 0 if there are no entries in sheet2 that correspond to the entry on sheet1 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "jerry" wrote in message ... I have two lists, the unique field to both lists is the text(project name). How can I find what is not the same(meaning what is being left out)? thanks Jerry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| cannot find list in excel 2000 | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Linear Mode
