Thursday, January 2, 2014

yogi_Extract A List Of Names That Exist In Column A But Not In Column B (contaminated)

                                          Google Spreadsheet   Post  #1465
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-02-2014
post by Patric C(http://productforums.google.com/forum/?zx=ftkkyxcf4zk8#!category-topic/docs/spreadsheets/axej9go3HU0)
trying to use google spreadsheet to find names that appear in column A but not B.
I have a list of names in column A and a list of names in column B.  Some of the names in A are the same as B.  I am hoping to use google spreadsheet to find the names that appear in column A, but not column B.

Thanks,
Patrick
----------------------------------------------------------------------------------------------------------------------------------------------
please note that when the following formula
=filter(A2:A; isna(match(A2:A; B2:B; 0)))
that I have used in a solution posted in another thread did not work 
further investigation indicated that names in your column B list have some extraneous (other than space) characters