Differences between columns

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I have 2 columns that contain names and I want to compare the 2 and extract
the names the exist in column 1 that do not appear in column 2.
A B
Anna anna
Anna betty
Sam sam
Sam joe
Fred
Fred

What I would like to see from my output is just the name Fred. Why because
Fred exists in column A but not in column B. Ideally I would like to see the
name Fred only one time, but I would be ok with seeing it multiple times just
to get this working.
 
In C2
=IF(AND(COUNTIF(B:B,A2)=0,COUNTIF($C$1:C1,A2)=0),A2,"")
copy down as needed. Now do a filter to find all nonblank values in column C.
 
Hi,

Assume that the range is in C5:D10. In C4, type "Name" and in D4, type
"Name 1". In C12, type "Names". In C13, use the following formula
=COUNTIF($D$5:$D$10,C5)=0. Now go to Data . Filter > Advanced Filter and
select "Copy to another location". In the List range box, select, C4:C10
and in the criteria box, select, C12:C13. In the copy to box, select
F4:F10. Check the box for unique records only. Now click on OK.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
THank you for your quick responce and help with this issue, unfortunatly the
results I get are as follows.

anna anna 0
anna betty 0
sam sam 0
sam joe 0
fred amy 0
fred 0
 
Back
Top