Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to come up with a way to find the non-union of two lists. In
other words, I want to figure out error cases. I tried some COUNTIFS but I'm just banging my head against the wall at 2:13AM. There must be a simple solution. Here's what I roughly have. I'm looking for cases where one of the values in the Name column is NOT present in the Owner column. If all is well, every owner will have a valid name. I'm looking for cases where that isn't true. Name Owner Expected Result = 2 for Skippy and Scooby Jim Jim Joe Jim Bob Bob Sue Skippy Sandy Joe Sandy Scooby Sandy Bob Thanks in advance! -- Just remember, wherever you go...there you are. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel lack of compatibility | Excel Discussion (Misc queries) | |||
analysis of variance with lack of fit in excel | Excel Worksheet Functions | |||
Help with GUI (for lack of a better term) | Excel Discussion (Misc queries) | |||
Nice idea lack of knowledge! | Excel Discussion (Misc queries) | |||
Counting Entries in two lists | Excel Worksheet Functions |