| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing one column of names to another
I have two columns of names next to each other. I need to know which names
in column 1 are not in column 2, and have these listed in a 3rd column. Please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing one column of names to another
If A1 thru B5:
mike mike joe joe john john trevor david nigel george then in C1 enter: =IF(COUNTIF($B$1:$B$5,A1)=0,A1,"") and copy down to see: mike mike joe joe john john trevor david trevor nigel george nigel The only items in column C are in column A, but not in column B -- Gary''s Student - gsnu200750 "Kim" wrote: I have two columns of names next to each other. I need to know which names in column 1 are not in column 2, and have these listed in a 3rd column. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing two columns and finding matching names | Excel Worksheet Functions | |||
| Comparing two names | Excel Worksheet Functions | |||
| Comparing a column of names | Excel Worksheet Functions | |||
| Comparing Excel # and JPEG Names | Excel Worksheet Functions | |||
| comparing names in a list | Excel Discussion (Misc queries) | |||
Linear Mode
